Forum Discussion

ericOnline's avatar
ericOnline
Post Patron
5 years ago
Solved

Cannot convert null to timestamp

Hello,

I have a column of timestamps in Unix format. Many of the values are null. I don't want to drop nulls because the records they pertain to are critical. 

How do I handle these nulls and still convert this column to a timestamp using a Custom Column with the following code?:

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 8, 0,[unixTimestampColumn]/1000)

 Thank you

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @ericOnline, try how

    if [unixTimestampColumn] is null, then null else #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 8, 0,[unixTimestampColumn]/1000)