Revision 7543
Added by Aaron Marcuse-Kubitza almost 12 years ago
my2pg.data | ||
---|---|---|
12 | 12 |
echo 'SET escape_string_warning = off;' |
13 | 13 |
sed \ |
14 | 14 |
-e "s/'0000-00-00( 00:00:00)?'/'-infinity'/g" \ |
15 |
-e "s/('[[:digit:]]{4}-)00-00(')/\101-01\2/g" \ |
|
16 |
-e "s/('[[:digit:]]{4}-[[:digit:]]{2}-)00(')/\101\2/g" \ |
|
15 | 17 |
"$@" |
Also available in: Unified diff
my2pg.data: Translate indefinite dates (dates with 0 as the month or day)