Time stamp

Database
Enthusiast

Time stamp



Hi all
in may table definition i have given that format:

transaction_Start_Date TIMESTAMP(6) FORMAT 'MM/DD/YYYY-HH:MI:SS',
transaction_End_Date TIMESTAMP(6) FORMAT 'MM/DD/YYYY-HH:MI:SS',

when i want to insert a date in that table the error is coming character string
fail to conversion to a numeric value . plz help me .if any one have idea. what
will be the syntex fro casting a date in teraData

Neeraj shukla

2 REPLIES
Enthusiast

Re: Time stamp

The casting is similar to DDL:
CAST('02/03/2009-01:25:11' AS TIMESTAMP FORMAT 'MM/DD/YYYY-HH:MI:SS')

-Petr

Enthusiast

Re: Time stamp

thanks peter
now i am successfully using that thing
my issue has resolved
Neeraj shukla