How will i insert timpstamp into a table

pankajupadhyay · New User Joined: 04 May 2007 Posts: 13 Location: pune

question1>>>>>i have a table . Table1

col1 col2 timestamp
a v
d b
b n
c p

the timestamp column is empty how will i insert timpstamp in that write query.........

que 2>>> day,time,date,timestamp takes howmach bytes and HOW

Que 3>>>> view is updatable or not.

raviprasath_kp · New User Joined: 20 Feb 2005 Posts: 65 Location: chennai

hi ur going to alter the table or u want to insert the fields

if u want to update the fileld use below qurey

UPDATE table a timestamp = ' '
WHERE id = 'OSISIN';

pankajupadhyay · New User Joined: 04 May 2007 Posts: 13 Location: pune

Hi,
Thanks for reply. I want to insert current time stamp.

somnath · New User Joined: 21 Mar 2005 Posts: 18 Location: India

There is a keyword CURRENT TIMESTAMP.
U can use that to insert the current timestamp into that field.
U'r query will be somewhat like below:

Insert into table_name
(colA,colB,timestamp)
values
('X','Y',CURRENT TIMESTAMP)