current date and time 1

[TheNegotiatorX]

i need to insert the current date and time into a table. I am working with session variables using coldfusion.....i need to insert values into a table of all the visits made to our website.....

when i created the visit table, i created a field with the data type being date/time.....

how do insert the current date and time into the table ...is there a specific function for this procedure

ex.
insert into visit values ('#id#', '?????');

?????-> being the current date.

help me please....
thanks

 

[cdukes]

Why not set up the table with a default value as getDate(), then you never need to worry about inserting the data you only need to insert the ID

Insert into visit values ('#id#')

the date will be automatically created for you,

Hope this helps,

Chris Dukes