numeric/time convertion

[#1]

Hi all

Please help me to convert in data format :

update time	scan time
42307.523784722	42306.616273148

[oknotsen]

Put the date() function around those values when loading.

[sunny_talwar]

or even TimeStamp() to see the Date and Time part of the field.

Update:

LOAD TimeStamp([upload time]) as [upload timestamp], //Date and Time

          Date(Floor([upload time])) as [upload date], //Only Date

          Time(Frac([upload time])) as [upload time]  //Only Time

FROM Source

[MarcoWedel]

another option to convert to dates (without time information):

DayName([update time]) as [update time]

hope this helps

regards

Marco

[SatyaPaleti]

Hi

Better Use TimeStamp(update time)

Thank you,

Satya Paleti

[jagan]

HI,

Try using TimeStamp() like below

LOAD

TimeStamp([update time]) AS [update time],

TimeStamp([scan time]) AS [scan time],

'

'

'

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[Kushal_Chawda]

You have fraction part also which means it has time information also.

So use Timestamp(update_time)  as Update_Time

Timestamp(scan_time)  as  scan_time

[kashaboinaraj]

Hi

you can use timestamp()

timestamp(updated_time) as Update_Time

timestamp(scan_time) as Scan_time

Regards

vishnu

[oknotsen]

Can I assume that you liking my answer but not replying to the topic means that your question is answered?

If so, please flag a Correct answer and optionally one of more Helpful answers.

If not, please make clear to us what (related to this topic) you need more explanation about.

[manojkulkarni]

Try this, it is working for me

=Date(42307.523784722,'DD-MM-YY')