How to insert date/time to sql database

[tanja256]

Hi,

I would like to insert date and time alongside with my data receiving from the sensor.

Right now i can insert data into sql table everytime when the data changes but i also wanted to insert the date and time as well.

Thank you in advance!

[Dennis_Knutson]

Simpler to just set the date/time column to automatically write the date when you insert a new row.

[aputman]

I create a field that is a datetime and set the default value to getdate().  So everytime i make an entry into this database, it automatically adds a datestamp.