Re: How to cast string to timestamp

Cao, Wenhong wrote: Hi, I am trying to get the records for the activationstamp within a certain range. The activationstamp is defined as character(14) in the ddl. I don't know how to cast the activationstamp field to timestamp before doing the comparison. I tried to use date(), but it didn't work.

How to cast string to timestamp

Hi, I am trying to get the records for the activationstamp within a certain range. The activationstamp is defined as character(14) in the ddl. I don't know how to cast the activationstamp field to timestamp before doing the comparison. I tried to use date(), but it didn't work. My server version