The MySQL now() function in MSSQL
If I want to insert the current time into a field when doing an insert in MySQL I usually use the NOW() function. It’s built right into the query string and makes sure you get the time of insert. In MSSQL though you have to change things to getDate(). If you have a date field, it will adapt to your type, but you can also specify a format of the date as the parameter.