All Forums Database
yarekshy85 3 posts Joined 06/16
13 Jun 2016
Convert text to a timestamp

Hi All,
I am trying to replicate the below vertica conversion to timestamp to teradata, But I am getting error. Can someone please guide me?
Vertica:
to_timestamp('June 7, 2016, Hour 0','Month DD, YYYY, Hour HH') 

--output:

'2016-06-07 00:00:00'

 

 

 

 
 

yuvaevergreen 93 posts Joined 07/09
14 Jun 2016

CAST(CAST(TO_TIMESTAMP(OREPLACE('June 07,2016,HOUR 1','HOUR',''),'MONTH dd,yyyy,HH24') AS VARCHAR(19)) AS TIMESTAMP(0))

krishna1985 13 posts Joined 08/16
09 Aug 2016

Hi All I am trying to convert

 2016-08-03 8:32:03

2016-08-03 11:56:34 

which are in varchar to timestamp. can you please help me

Regards,
Hari Krishna

Inguva 4 posts Joined 08/16
10 Aug 2016
sel to_timestamp('june 7,2016,12' ,'Month DD,YYYY,HH')

Try This It worked for me

You must sign in to leave a comment.