members_table "date registered". what format is that in?

Started by rcane, January 17, 2022, 01:51:13 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

rcane

January 17, 2022, 01:51:13 PM
It doesn't appear to be any type of numerical reference that excel would deal with.

Trying to sort be when registered--on a csv I pulled down.

Aleksi "Lex" Kilpinen

#1
January 17, 2022, 01:54:40 PM
Most dates are saved in Epoch, without checking I'm going to guess this is as well https://www.epochconverter.com/
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Arantor

#2
January 17, 2022, 02:00:21 PM
Yup, it's a Unix timestamp, number of seconds since 1/1/1970. You can also add the fROM_UNIXTIME() function to your existing reporting, e.g. SELECT id_member, member_name, FROM_UNIXTIME(date_registered) FROM smf_members.

rcane

#3
January 17, 2022, 02:02:59 PM
Quote from: Aleksi on January 17, 2022, 01:54:40 PMMost dates are saved in Epoch, without checking I'm going to guess this is as well https://www.epochconverter.com/

ahhhh, thankya.

rcane

#4
January 17, 2022, 02:04:08 PM
Quote from: Arantor on January 17, 2022, 02:00:21 PMYup, it's a Unix timestamp, number of seconds since 1/1/1970. You can also add the fROM_UNIXTIME() function to your existing reporting, e.g. SELECT id_member, member_name, FROM_UNIXTIME(date_registered) FROM smf_members.

thanks for this too
Print
Go Up Pages1
User actions
Advertisement: