Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If it is so, then try:
Load
Date(25569+YourNumberField/3600/24) as Date
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?
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
What is the interpretetion of getting 14 mar 2014 from that number?
As I understand, it is time in seconds after 01/01/1970
So, the answer is
timestamp(makedate(1970) + 1394818200/86400)
If it is so, then try:
Load
Date(25569+YourNumberField/3600/24) as Date
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
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.