Epoch Time Convert

[nehru]

Need help pls.

i want to convert a EPOCH Time eg( 1264658850 )
to a date/time format eg( 01/28/2010 02:07:26 00 PM )

tnx.

[Steve Wood]

Re: Epoch Time Convert

I looked and there is no built in function. So you would have to find the forumla, or sample code from some other language and adapt to Xbasic, write a function.

[csda1]

Re: Epoch Time Convert

Need help pls.

i want to convert a EPOCH Time eg( 1264658850 )
to a date/time format eg( 01/28/2010 02:07:26 00 PM )

tnx.

Basic formula is

?ctodt("01/01/1970")+1264658850+(gettimezoneoffset()*3600)
= 01/28/2010 01:07:30 00 am

I can't account for the 11 hour difference in your time, but I suspect it is due to some issue with the time zone or daylight savings time that you didn't account for in the conversion you gave

The seconds do not account for leap seconds. If you want to do that, you'll need a function to process those leap seconds. If you are just subtracting 2 times, the seconds don't matter if you don't cross a leap second date.

[G Gabriel]

Re: Epoch Time Convert

?{1/1/70}+[b]1264658850[/b]/86400
= {01/28/2010}

edit...
Just noticed you want date/time. Will catch up with you later, have to go to a meeting...

[G Gabriel]

Re: Epoch Time Convert

Subject to further testing, I think this UDF should do it:

FUNCTION Epoch_to_DT AS A (epoch_date AS N )
	d={1/1/70}+epoch_date/86400
	x=mod(epoch_date,86400)
	hs=int(x/3600)
	ms=int(mod(x,3600)/60)
	ss=mod(mod(x,3600),60)
	dd=d+" "+padl(hs+"",2,"0")+":"+padl(ms+"",2,"0")+":"+padl(ss+"",2,"0")
Epoch_to_DT=ctodt(dd)
END FUNCTION

P.S.
Doesn't account for leap seconds. I sure hope you are not adamant about leap seconds unless you work for NASA.

[nehru]

Re: Epoch Time Convert

:D tnx for the help guys
more power to all :)

1 more help guys pls.

how about in other way (reverse)
date/time to EPOCH Time

[G Gabriel]

Re: Epoch Time Convert

x=now()
?int(x-ctodt("01/01/1970 12:00:00 am"))
= 1264751422

[robert]

Re: Epoch Time Convert

Truly amazing! I'm a retired scientist\engineer turned 65 and never heard of Epoch time until now. The breadth of knowledge in this forum never ceases to amaze me. Keep it up guys.

[nehru]

Re: Epoch Time Convert

tnx to all and specially to G Gabriel

more blessings to all and to our family.
i love this forum and my a5.

nehru

[robert]

Re: Epoch Time Convert

For anyone else like myself who is ignorant of Epoch time and would like to know more about it, here's a good reference- http://www.esqsoft.com/javascript_ex...e-to-epoch.htm

[dfricke10]

Re: Epoch Time Convert

I know this thread is a bit old, but I've just run into this issue. I have a PHP script that is entering the Epoch datetime into the database. I need to pull that number and convert it to a readable date/time. And then also be able to create a record and inserting the Epoch datetime into the database so the PHP script can read it.

So, I kinda understand what is happening here. But I'm not sure how to do it or where to enter the function. Any help would be appreciated.

[G Gabriel]

Re: Epoch Time Convert

I need to pull that number and convert it to a readable date/time. And then also be able to create a record and inserting the Epoch datetime into the database so the PHP script can read it.

Not sure which one(s) of these steps are you having trouble with. Post an example for further assistance.

[dfricke10]

Re: Epoch Time Convert

Pretty much all of it. I have a field called date which has the epoch datetime format. Just trying to convert it to readable date time from the records saved already from the PHP script, and then when the user through A5 saves a new record, it store the epoch datetime from the readable date time. Make sense? I understand I need a function, but don't know where to put it.

And yes, I'm still new to Alpha. :)

[dfricke10]

Re: Epoch Time Convert

Update:
I've got the script to display the datetime from the current epoch field using:

ctodt(dtoc(date() ) + " " + time() )

in the Display Format of the date field. Converts nicely. Now to get it so when the user adds a new record, it converts the readable datetime to epoch and stores it.

This would be a hidden field on the New Record screen.

[G Gabriel]

Re: Epoch Time Convert

One way is to put it in a calc field, or
You could add another field to your table then with an update operation populate it using the epoch function.