LCID Local Date / Time

[Headshot001]

I have my pages hosted on a US server however I am in Australia. I am trying to get the Date & Time to write / read in my local time format. I have looked around and found out about LCID however it does not seem to be helping this issue.

My code is as follows
---------------------
first1=rsProducts.Fields.Item("First&quot.Value
last1=rsProducts.Fields.Item("Last&quot.Value
mobile1=rsProducts.Fields.Item("Mobile&quot.Value
message1=rsMessage.Fields.Item("Message&quot.Value
Session.LCID = 3081
date1=Date()
time1=Time()


set comSMSLog = Server.CreateObject("ADODB.Command&quot
comSMSLog.ActiveConnection = MM_smsLog_STRING
comSMSLog.CommandText = "INSERT INTO SMSLog (First, Last, Mobile, Message, TimeSent, DateSent) VALUES ('"&first1&"', '"&last1&"', '"&mobile1&"', '"&message1&"', '"&time1&"', '"&date1&"')"
comSMSLog.CommandType = 1
comSMSLog.CommandTimeout = 0
comSMSLog.Prepared = true
comSMSLog.Execute()
-----------------------------

However - when I read the date and time coming back in using this...

<%=(rsLogSearch.Fields.Item(&quot;TimeSent&quot.Value)%></td>
<%=(rsLogSearch.Fields.Item(&quot;DateSent&quot.Value)%></td>

I still get the US times and dates. Has anyone got any advice they could offer? It would be greatly appreciated.

NB: I cannot alter the global.asa file on my server.

 

[sarav45]

Hi,

r u fetching the value from DB and showing it out , or just setting the LCID value and getting the Date and Time value..
If u send the the o/p format u r getting in ur browser , we can give the clear picture of ur problem