SQL PHP HTML ASP JavaScript articles and free scripts to download

Formatted date and time variable to store in MSSQL

We 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.

dtm="8/17/2007 7:44:56 PM"

Here the variable dtm stores the formatted date and time value. Let us try with one invalid date and time value like this

dtm="8/17/2007 7:74:56 PM"

The date and time field will generate an error message saying like this

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "8/17/2007 7:74:56 PM"]'
/a/dt/insert.asp, line 29

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.

Dim dtm
dtm="8/17/2007 7:54:56 PM"
Response.Write dtm

if isDate(dtm) Then
rs.open "insert into dt(book_id,issue_dt) values( 9,'"& dtm & "')", conn
else
Response.Write "Please enter a valid date and time "
End if

You can read the tutorial on how to collect date values from the user.

Number of User Comments : 1


Google+

Harsh Sehgal02-04-2013
i want date in numeric format without /(slash or back slash) .for example 3 0 0 4 2 0 1 3 (i.e 30/04/2013)
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer