Jump to content

Archived

This topic is now archived and is closed to further replies.

realtek

Update a timestamp field?

Recommended Posts

Hi,

 

I am aware of how to use the update query.

 

However, could someone please advise me of how to update a timestamp field, seeing as the timestamp is automatically generated?

 

Thanks!,

 

Nick

Share this post


Link to post
Share on other sites

As u said time stamp is the value at the point of record insertion.

 

and u can have varying length

 

TIMESTAMP(14) YYYYMMDDHHMMSS

TIMESTAMP(12) YYMMDDHHMMSS

TIMESTAMP(10) YYMMDDHHMM

TIMESTAMP(8) YYYYMMDD

TIMESTAMP(6) YYMMDD

TIMESTAMP(4) YYMM

 

 

u can use something like ( example) this

 

update test set dt=\'20030523203030\'

 

If dont give the correct format u will just see 0000000 being updated

 

So check the value u have given in time stamp!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.