Formatted date and time variable to store in MSSQLWe can format a date and time value before storing them or inserting them to a date and time field in MSSQL table. Here is a formatted date and time value which can be stored in record.
Here the variable dtm stores the formatted date and time value. Let us try with one invalid date and time value like this
The date and time field will generate an error message saying like this
So it is always a good idea to check the date and time by using isDate function and then we can insert the date value to our MSSQL table.
Here is the code to add a date variable to our record.
You can read the tutorial on how to collect date values from the user.
This article is written by plus2net.com team.
Number of User Comments : 1