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 tend

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 colu

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

2002-12-23 Thread Dana Diederich
]] > Sent: Monday, December 23, 2002 9:16 AM > 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 >

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