Re: TimeStamp in MySQL reqd NULL

2002-12-23 Thread Keith C. Ivey
On 23 Dec 2002, at 16:11, Akash wrote: According to MySQL implementation, if I give the default value of the column during table creation as NULL, it will store the current time in the timestamp column. I do not want this current time to be stored in the timestamp column. I want it to be

What, if anything, is wrong with UNIX Epoch time stamps? [Was: RE: TimeStamp in MySQL reqd NULL]

2002-12-23 Thread Dana Diederich
To: [EMAIL PROTECTED] Cc: Akash Subject: Re: TimeStamp in MySQL reqd NULL On 23 Dec 2002, at 16:11, Akash wrote: According to MySQL implementation, if I give the default value of the column during table creation as NULL, it will store the current time in the timestamp column. I do

re: TimeStamp in MySQL reqd NULL

2002-12-23 Thread Victoria Reznichenko
On Monday 23 December 2002 12:41, Akash wrote: I want to store NULLS or '0' in a column which is of type TimeStamp. According to MySQL implementation, if I give the default value of the column during table creation as NULL, it will store the current time in the timestamp column.

RE: What, if anything, is wrong with UNIX Epoch time stamps? [Was: RE: TimeStamp in MySQL reqd NULL]

2002-12-23 Thread Dana Diederich
Date/Time is such a tricky thing. I think that's we migrated toward the simplest solution in the first place. For days/weeks/months, I think the math cited below works pretty well. That is, if we're not talking about calendar months. As soon as we need to query based on calendar things, we