How to convert varchar to datetime

• murali.veluvali

  Grasshopper

  Points: 17

  More actions

  April 29, 2008 at 3:41 am

  #154315

  Hi all

  I have a one table with two columns

  Column Name -- DataType

  StartDate -- varchar(128)

  NewStartDate -- DateTime

  the values in the startdate column is

  20080314

  20080319

  20080409T095627.115 GMT

  20080409T100238.767 GMT

  now i want to insert that values into newstartdate column

  so i request to all please help me

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 29, 2008 at 9:18 am

  #808467

  You may try something like below:

  SELECT CAST(SUBSTRING('20080314',5,2)+'/'+SUBSTRING('20080314',7,2)+'/'+SUBSTRING('20080314',1,4) AS DATETIME)