[freddie007]

1. If i need to add into the database time now() of singapore time, how do i do it??


now() + ______



2. If I need to output the time now of singapore , how??

<cfoutput>#now() + __________#</cfoutput>

[acoder]

Is this for anywhere throughout the world? You only want to output Singapore time, not the local time?

[freddie007]

Yes for sigapore time only

because I want to set now() Singapore time to add to the database



<cfset form.aaDate='#now()#'>

where aaDate is always the singapore time.

thanks

[acoder]

Try the DateConvert() function. If the local computer is Singapore time, then that should be OK. If not, you'll have to convert it. TimeZoneInfo() may help too.

[freddie007]

The server is a US server
so time now is not accurate

<cfset curDate = Now()>

<cfset utcDate = DateConvert("local2utc+8", curDate)>


How do I add +8 hours to the UTC time??

[acoder]

You could try converting the locale using setLocale(). If that doesn't give the desired result, then for want of a better solution, try DateAdd with the number of hours from UTC.

[freddie007]

sorry to ask

but is the statement as follow correct??

Expand|Select|Wrap|Line Numbers

1. <cfset curDate = Now()>
2. <cfset utcDate = DateConvert("local2utc", curDate)>
3. <cfoutput>#DATEADD(hh, 8, utcDate)#</cfoutput>

[acoder]

The first parameter should be a string and it's "h", not "hh".

[freddie007]

I get an error

ts '2008-10-08 09:36:18'} {ts '2008-10-08 16:36:18'}

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request
Variable H is undefined.


Resources:

[acoder]

As I said, it should be a string:

Expand|Select|Wrap|Line Numbers

1. <cfoutput>#DATEADD("h", 8, utcDate)#</cfoutput>

[freddie007]

Ok, done, thanks.

A LOT !!

CHEERS! ;-)))))))))))))

[acoder]

You're welcome. Glad it's working :)