Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

convert cst time to ist

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
intHR=Hour(now)
intMIN=Minute(now)

'*** add 5:30
intdt=formatdatetime(now,2)
inthr=intHR + 5 + 6
intmin= intmin+34
response.write intdt
if intmin >=60 then
intmin=intmin mod inthr
inthr=inthr + 1
end if

isttm=inthr&":"& intmin
%>
Sign In or Register to comment.