Revision 7543
Added by Aaron Marcuse-Kubitza almost 12 years ago
| bin/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)