Problem Converting Timestamp --> Time & Date (Seperate Columns)

[#1]

Hi folks,

Issue at hand, please have a look at the images below.

In the script, the code used to make the split were:

time(frac(d_create_time),'hh:mm:ss') as Time_MT,

date(frac(d_create_time),'YYYY-MM-DD') as Date_MT,

When trying to split the column into two, the date values go haywire and its all consistent throughout the whole field showing a the value = "1899-12-30". Please advise. Thanks.

Best Regards,

R

[tresesco · Accepted solution]

Try the date part like:

date(floor(d_create_time),'YYYY-MM-DD') as Date_MT,

Or simply:

date(d_create_time,'YYYY-MM-DD') as Date_MT,

[#3]

Hi tres, THANKS! LEGEND! works perfectly.

[MK_QSL]

Try below in your script...

Date(Floor(Timestamp#(d_update_time,'YYYY-MM-DD hh:mm:ss'))) as Date,

Time(Timestamp#('2014-01-05 17:58:35','YYYY-MM-DD hh:mm:ss'),'hh:mm:ss') as Time