Inserting sysdate and time into the coloumn whose datatype is datetime 2

[daka94]

Dear friend,
i want to insert system date and time into the coloumn whose datatype is datetime.
please help me
thank you in advance
daka

 

[tlbroadbent]

Use the getdate() function.

Insert Tbl (col1, col2, datetimecol, ...) values (val1, val2, getdate(), ...) Terry

http://members.home.net/tlbroadbent/index.htm

 

[foxdev]

Reading between the pixels, you can also make the column have a default value of (getdate()), so that the record is automagically timestamped when you insert it (unless, of course, you explicitly provide a value). Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com

 

[tlbroadbent]

Robert,

Excellent recommendation. Terry

http://members.home.net/tlbroadbent/index.htm

 

[mukund]

When you design a table, you can specify the Default Value for a datetime/smalldatetime column as getdate()

getdate() function will return a system date.

This way you don't have to specify that column in your insert query.

Hope this helps.

Mukund. (j.mukund@zensar.com)