How to set default values for timestamp fields

[My Deja]

what is the syntax for specifying the default values for timestamps in
MySQL in the CREATE TABLE command?

I have 2 timestamps, one for when the record was entered, the other
for any subsequent updates.

I know that the first timestamp column will be set automatically on
updates, but how does the other for creation timestamp get set.

My app is not generating the SQL directly so setting the value using
the NOW() command is not an option, as the inserts are coming from
different timezones I cannot let the clients set their own values.

[SR]

On 24 Feb 2004 02:09:47 -0800, My Deja wrote:

My app is not generating the SQL directly so setting the value using
the NOW() command is not an option, as the inserts are coming from
different timezones I cannot let the clients set their own values.

If the SQL string is executed server side, the now() function returns
server date and time.

[SR]

On 24 Feb 2004 02:09:47 -0800, My Deja wrote:

My app is not generating the SQL directly so setting the value using
the NOW() command is not an option, as the inserts are coming from
different timezones I cannot let the clients set their own values.

If the SQL string is executed server side, the now() function returns
server date and time.

[SR]

On 24 Feb 2004 02:09:47 -0800, My Deja wrote:

My app is not generating the SQL directly so setting the value using
the NOW() command is not an option, as the inserts are coming from
different timezones I cannot let the clients set their own values.

If the SQL string is executed server side, the now() function returns
server date and time.

[bobb]

The default value isn't dynamic (I don't think, anyway)
I would think you could do this like so...
on an insert, both would tstamps have the same initial value (system
clock)...
on an update, just include

update table set field = value, tstamp1 = tstamp1 where whatever whatever
whatever...
if you always do tstamp1 = tstamp1 in you updates, than tstamp1 will always
be the original value that was there during the insert.

if you don't do it, it'll get a new timestamp (which would match tstamp2,
incidentally).

Good luck.

bobb

"My Deja" <my********@yahoo.co.uk> wrote in message
news:90**************************@posting.google.c om...

what is the syntax for specifying the default values for timestamps in
MySQL in the CREATE TABLE command?

I have 2 timestamps, one for when the record was entered, the other
for any subsequent updates.

I know that the first timestamp column will be set automatically on
updates, but how does the other for creation timestamp get set.

My app is not generating the SQL directly so setting the value using
the NOW() command is not an option, as the inserts are coming from
different timezones I cannot let the clients set their own values.

[bobb]

The default value isn't dynamic (I don't think, anyway)
I would think you could do this like so...
on an insert, both would tstamps have the same initial value (system
clock)...
on an update, just include

update table set field = value, tstamp1 = tstamp1 where whatever whatever
whatever...
if you always do tstamp1 = tstamp1 in you updates, than tstamp1 will always
be the original value that was there during the insert.

if you don't do it, it'll get a new timestamp (which would match tstamp2,
incidentally).

Good luck.

bobb

"My Deja" <my********@yahoo.co.uk> wrote in message
news:90**************************@posting.google.c om...

what is the syntax for specifying the default values for timestamps in
MySQL in the CREATE TABLE command?

I have 2 timestamps, one for when the record was entered, the other
for any subsequent updates.

I know that the first timestamp column will be set automatically on
updates, but how does the other for creation timestamp get set.

My app is not generating the SQL directly so setting the value using
the NOW() command is not an option, as the inserts are coming from
different timezones I cannot let the clients set their own values.

[bobb]

The default value isn't dynamic (I don't think, anyway)
I would think you could do this like so...
on an insert, both would tstamps have the same initial value (system
clock)...
on an update, just include

update table set field = value, tstamp1 = tstamp1 where whatever whatever
whatever...
if you always do tstamp1 = tstamp1 in you updates, than tstamp1 will always
be the original value that was there during the insert.

if you don't do it, it'll get a new timestamp (which would match tstamp2,
incidentally).

Good luck.

bobb

"My Deja" <my********@yahoo.co.uk> wrote in message
news:90**************************@posting.google.c om...

what is the syntax for specifying the default values for timestamps in
MySQL in the CREATE TABLE command?

I have 2 timestamps, one for when the record was entered, the other
for any subsequent updates.

I know that the first timestamp column will be set automatically on
updates, but how does the other for creation timestamp get set.

My app is not generating the SQL directly so setting the value using
the NOW() command is not an option, as the inserts are coming from
different timezones I cannot let the clients set their own values.