MySQL base time?

by "Keith D Sellars" <Keith(at)webgraffix.com>

Date:	Tue, 29 Apr 2003 21:26:03 -0400
To:	<hwg-languages(at)hwg.org>
	todo: View Thread, Original

One of my databases has a field titled "time" which records the time a
transaction occurs.  One such time is: 1051649099.

I know this is in seconds and counts from a base date (don't know the
correct term for that starting date, so please forgive my ignorance).

What is the actual date from which the time is based and what is the correct
term for that date?

I thought the starting date was something like  Jan 01,1970 at midnight.
Assuming I am correct, then this date would represent April 5, 2003.

Am I correct in this?

Thanks,
Keith D Sellars
WebGraffix
www.webgraffix.com

"Making database sites seem easy"

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA

This page is part of a preserved archive of archives.hwg.org. The site is no longer active and its content is not maintained. For enquiries about this archive, write to archive(at)iwanet.org.