I am trying to insert a Time into my SQL database using ASP.
The server is using CST time and would like to convert the system time into IST time before inserting.
I could convert the time but it is giving me formatdatetime error after 12.30 midnight IST.
Kindly help ASAP.
This is how I am getting the IST time
dim intHR, intMIN
'*** add 5:30
inthr=intHR + 5 + 6
if intmin >=60 then
intmin=intmin mod inthr
inthr=inthr + 1