Date Format + NUM

[Anonymous]

Hi folks,

I Have a date Field in the following format YYYY-MM-DD hh:mm:ss now i want to to convert into Number  in script

i.e  Num(Date#(TransactionDate,'YYYY-MM-DD hh:mm:ss')) as TransactionDt

but the problem here is im getting output as 42400.2564123.. where i dont want decimal value.

expected output : 42400.

[MarcoWedel]

‌use floor() instead of num.

regards

Marco

[HirisH_V7]

Hi,

Try this,

ceil(Num(Date#(TransactionDate,'YYYY-MM-DD hh:mm:ss'))) as tdate,
Date#(Floor(TransactionDate),'YYYY-MM-DD hh:mm:ss') as tdate2

The Date Function

HTH,

Hirish

[maxgro]

you ca use floor and frac to get the date and time part