Joindate format in MySql of vBulletin

[Forero]

Could someone please tell me how to read this data?

I need to know the registration date (time-stamp) of all the users in my forum.

I downloaded the user table as a csv file, but I can not read the joindate column.

The column looks like this (with many more records):

joindate
1195762080
1195942320
1197122400
1197121080
1197312817
1197313767
1197335040
1197340817
1197370440
1197378719

Thanks in advance for your help.

[kh99]

They are in "unix time" format (number of seconds since Jan 1 1970). If you google "convert unix time" you'll find a bunch of info on converting it.

[Forero]

That's great.

I googled it and found the converter in two seconds flat.

Thank you very much kh99

[kh99]

No problem, but I probably should have mentioned: I'm assuming you have your csv file and now you're working on processing it externally (not in vbulletin or php), because there is a php function to convert it to a text representation and a vBulletin function to do it using the date format options. So if you're working in vbulletin code (or really, probably any programming language), there's no reason to figure out your own conversion.