ConvertToLocalTime Help...

[#1]

Hello all,

I want to use ConvertToLocalTime function for UNIX date format in source file.

My format which is provided is in ex:1394818200 format.

How to assign parameters for converting UNIX to Date & Time format .

i have tried following format in text box but not sure whether correct or not:

=ConvertToLocalTime(timestamp((25569+(max(TIME)+3600000)/(1000*24*3600))), 'GMT-01:00')

Thanks in Advance

Thanks & Regards,

Harshal

[tresesco]

I am not very much acquainted with Unix. Can you interpret the sample date '1394818200' somehow, may be like MMDDYYYsshh or some other meaningful way?

[#3]

Hi tresesco,

For ex. 1394818200 conversion is Fri, 14 Mar 2014 17:30:00 GMT.

if we use timestamp function or date# then by which way is it possible .

Thanks,

Harshal

[tresesco]

What is the interpretetion of getting 14 mar 2014 from that number?

[Anonymous]

As I understand, it is time in seconds after 01/01/1970

[Anonymous]

So, the answer is
timestamp(makedate(1970) + 1394818200/86400)

[#7]

Hi tresesco,

With help of this url i found that,

Online Conversion - Unix time conversion

[tresesco · Accepted solution]

If it is so, then try:

Load

          Date(25569+YourNumberField/3600/24) as Date

[#9]

Hi tresesco,

Thanks a lot for help .

Thanks Michael

tresesco please can u give brief for making use of 25569+YourNumberField/3600/24 .

Thanks & regards,

Harshal

[tresesco]

Your input is in seconds after the date 01/01/1970. To get day(1-one day) equivalent we need to divide seconds by 60*60*24. The date 01/01/1970 is numericcaly equivalent to 25569. Hence.... Hope this helps you comprehend.