Null to Timestamp

[jpraveen]

Hi

while i am converting a null value to Time-stamp,the job is getting aborted with the error

APT_CombinedOperatorController,0: Conversion error calling conversion routine timestamp_from_string data may have been lost

and i had written the logic as

Code: Select all

If IsNull(OUT_PROVIDER_FACILITY.BEG_EFF_DATE) Then StringToTimestamp(18581117) Else OUT_PROVIDER_FACILITY.BEG_EFF_DATE

i want the output as 1858-11-17 00:00:00 for all null values,
can any one post the code to me.


Thanks
Praveen

[PhilHibbs]

Try StringToTimestamp("1858-11-17 00:00:00")

[chulett]

You need to supply a matching format mask so it knows how to parse the incoming string.