StringToDate

platonfi · Post by **platonfi** » Tue Jun 10, 2008 4:55 am

Hi!
SELECT TO_CHAR
(EVENT_TIMESTAMP, 'YYYY-MM-DDHH24:MI:SS') from SOURCE
-> need to convert field for datetime -format, but HOW?

StringToDate or StringToTime? I

Reg Minna

karthik_j013 · Post by **karthik_j013** » Tue Jun 10, 2008 5:08 am

You can use stringtotimestamp.

karthik_j013 · Post by **karthik_j013** » Tue Jun 10, 2008 5:08 am

You can use StringToTimestamp.

platonfi · Post by **platonfi** » Tue Jun 10, 2008 5:31 am

stringtotimestamp, what is a syntax?

ArndW · Post by **ArndW** » Tue Jun 10, 2008 5:58 am

The syntax is well-document in the DataStage Parallel Job Developer Guide and is StringToTimeStamp({column},{format}). In your case the format would be '%yyyy-%mm-%dd%hh:%nn:%ss'

platonfi · Post by **platonfi** » Tue Jun 10, 2008 7:27 am

Thanks a lot!!

Reg Minna