Page 1 of 1
timestamp_format -> not a valid format
Posted: Wed Jun 20, 2007 4:12 am
by ivannavi
Sequential_File_7: Error when checking operator: At field "dat": When validating import/export function: "timestamp_format" property value (%dd%mm%yyyy) is not a valid format.
The column that this date comes from is timestamp SQL type.
If I leave the default format (%yyyy-%mm-%dd %hh:%nn:%ss) it writes to file without problems. But if I specify something else, it's a fatal error.
Is there a list of valid formats. What am I doing wrong?
Posted: Wed Jun 20, 2007 6:11 am
by ray.wurlod
A timestamp format string must have both a date portion and a time portion. Yours just has a date portion.
Posted: Wed Jun 20, 2007 8:14 am
by samsuf2002
You can use TimestamptoDate() function if you want only date part from your input timestamp and you can specify your default date format in your target stage.
Posted: Wed Jun 27, 2007 7:30 am
by ivannavi
A timestamp format string must have both a date portion and a time portion. Yours just has a date portion. [/quote]
Didn't know that. Resolved.
Posted: Wed Jun 27, 2007 7:31 am
by ivannavi
A timestamp format string must have both a date portion and a time portion. Yours just has a date portion. [/quote]
Didn't know that. Resolved.