The data which coming from source is varchar2 = '2010-01-25' yyyy-mm-dd
I like to convert into Timestamp I've tried following function but seems not working
Code: Select all
svApptDate =
if IsValid("date",SCH_N_Referral_Delta.FIRST_APPT_DATETIME,"%dd-%mm-%yyyy") then StringToDate(SCH_N_Referral_Delta.FIRST_APPT_DATETIME,"%dd-%mm-%yyyy") else ' '
Code: Select all
svApptDateFormat =
TimestampFromDateTime(svApptDate,'00:00:00')
Code: Select all
if IsValid("date",SCH_N_Referral_Delta.FIRST_APPT_DATETIME,"%yyyy-%mm-%dd") then StringToDate(SCH_N_Referral_Delta.FIRST_APPT_DATETIME,"%dd-%mm-%yyyy") else ' '
Appreciate your helpInvalid value for this date type: **********.