date format

[bhavvibudagam]

Hi,

can any one please help me

I have date field with number format Timestamp.

first one is the original foramt second one is the converted format

In the Converted format i am getting the one date many times ideally its not correct.

Please help me to resolve.

I have used the below script

Date(Num(VIOLATION_DATE),'MM/DD/YYYY') as VIOLATION_DATE,

Thanks

[kristof_j]

and if you use

Date(VIOLATION_DATE) as VIOLATION_DATE?

[#3]

Do this :

Date(floor(VIOLATION_DATE)) as NewDate

[MindaugasBacius · Accepted solution]

Try this:

Date(Floor(OLD_VIOLATION_DATE),'MM/DD/YYYY')

It will Round the number to the integer and duplicates will disappear.

[trdandamudi]

May be as below:

    Date(Num(Floor(VIOLATION_DATE)),'MM/DD/YYYY') as VIOLATION_DATE

[Chanty4u]

its working as below

aa:

LOAD * INLINE [

    Date

    40544

40544.010416667,

4054.09375

];

LOAD *

,

    Date(Num(Floor(Date)),'MM/DD/YYYY') as VIOLATION_DATE

Resident aa;