Convert timestamp to tick

Convert timestamp to tick

InsiteFX
Super Moderator
Posts: 6,803
Threads: 348
Joined: Oct 2014
Reputation: 248

#16

03-09-2018, 02:00 PM

Here are a couple more SQL Selects you can try:

PHP Code:
SELECT FROM_UNIXTIME((`TIMESTAMP` / 1000)) as mytime FROM `table`;

SELECT FROM_UNIXTIME((`TIMESTAMP` / 1000)) as mytime, TIMESTAMP mod 1000 as msec FROM `table`; 

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009. ( Skype: insitfx )

Messages In This Thread

Convert timestamp to tick - by omid_student - 03-07-2018, 06:14 AM

RE: Convert timestamp to tick - by omid_student - 03-07-2018, 06:18 AM

RE: Convert timestamp to tick - by Muzikant - 03-07-2018, 06:42 AM

RE: Convert timestamp to tick - by omid_student - 03-07-2018, 01:29 PM

RE: Convert timestamp to tick - by omid_student - 03-07-2018, 01:32 PM

RE: Convert timestamp to tick - by omid_student - 03-07-2018, 01:37 PM

RE: Convert timestamp to tick - by Muzikant - 03-07-2018, 06:40 AM

RE: Convert timestamp to tick - by InsiteFX - 03-08-2018, 04:50 AM

RE: Convert timestamp to tick - by omid_student - 03-08-2018, 09:41 AM

RE: Convert timestamp to tick - by InsiteFX - 03-08-2018, 10:07 AM

RE: Convert timestamp to tick - by omid_student - 03-08-2018, 10:51 PM

RE: Convert timestamp to tick - by InsiteFX - 03-08-2018, 03:45 PM

RE: Convert timestamp to tick - by omid_student - 03-08-2018, 10:51 PM

RE: Convert timestamp to tick - by InsiteFX - 03-09-2018, 06:15 AM

RE: Convert timestamp to tick - by omid_student - 03-09-2018, 07:00 AM

RE: Convert timestamp to tick - by InsiteFX - 03-09-2018, 02:00 PM

RE: Convert timestamp to tick - by omid_student - 03-09-2018, 10:47 PM

RE: Convert timestamp to tick - by omid_student - 03-09-2018, 11:58 PM

RE: Convert timestamp to tick - by omid_student - 03-10-2018, 02:01 AM

RE: Convert timestamp to tick - by InsiteFX - 03-10-2018, 07:18 AM

RE: Convert timestamp to tick - by InsiteFX - 03-13-2018, 03:22 AM