[BNM] MySQL date time formats

[Alan Newman]

It sounds like the date stored in milliseconds.

- Alan


-----Original Message-----
From: Oliver Marshall [mailto:Oliver.Marshall at g2support.com]
Sent: 04 July 2006 16:31
To: Brighton New Media
Subject: [BNM] MySQL date time formats


I am creating a web report pulling data from a MySQL database we have
here. 

The datetime field of this particular database (not created by me) is
set as the type "BIGINT" and the date and times in it are 13 number long
integers.

Is this a normal way of storing date/times in mysql? Any suggestions how
I can decipher the correct date from this ?

Olly

-- 

BNM info/subscription/archives: http://www.brightonnewmedia.org/

BNM archive search: http://www.roddis.org/bnm/search.php
BNM Del.icio.us tag: http://del.icio.us/tag/bnm/
BNM Flickr group: http://www.flickr.com/groups/bnm/

BNM powered by http://www.screen-play.net/