timestamp_format -> not a valid format

ivannavi · Post by **ivannavi** » Wed Jun 20, 2007 4:12 am

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?

ray.wurlod · Post by **ray.wurlod** » Wed Jun 20, 2007 6:11 am

A timestamp format string must have both a date portion and a time portion. Yours just has a date portion.

samsuf2002 · Post by **samsuf2002** » Wed Jun 20, 2007 8:14 am

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.

ivannavi · Post by **ivannavi** » Wed Jun 27, 2007 7:30 am

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.

ivannavi · Post by **ivannavi** » Wed Jun 27, 2007 7:31 am

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.