Re: UNIX_TIMESTAMP converts to CURRENT_DATE on a second call

2001-05-22 Thread Gerald Clark
Shankar Unni wrote: > Sinisa writes: > > >> - timestamp is saved in datetime format >> - first timestamp column is silently updated on each UPDATE > > > What this means, of course, is that when you want to deal with your own > TIMESTAMP data, you need to maintain some sort of sacrificial co

RE: UNIX_TIMESTAMP converts to CURRENT_DATE on a second call

2001-05-22 Thread Shankar Unni
Sinisa writes: > - timestamp is saved in datetime format > - first timestamp column is silently updated on each UPDATE What this means, of course, is that when you want to deal with your own TIMESTAMP data, you need to maintain some sort of sacrificial column (e.g. "LAST_UPDATED TIMESTAMP") that

Re: UNIX_TIMESTAMP converts to CURRENT_DATE on a second call

2001-05-19 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > The following line inputs the current UNIX time into a field - > date_start - with the date_stop filed defaulting to '0': > > insert into contract_work (sess_id,email,date_start) > values('bde32bfde3ac89c7d510df573bb6bb88','Joe Bloggs',unix_timest