Hi John, Thanks for your quick reply it will help for doing next coding.
Regards, Dhananjay Awachat --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Dhananjay- > > The simple answer is to subtract 9 hours from Japan Standard Time to get UT > or GMT: > > GMT = DateAdd("h", -9, LocalTime) > > If you want to verify the local time zone and offset, you'll have to call > the Windows API GetTimeZoneInformation function. > > http://msdn.microsoft.com/library/default.asp?url=/library/en- us/sysinfo/bas > e/gettimezoneinformation.asp > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of DHANANJAY > Sent: Monday, October 24, 2005 4:58 AM > To: [email protected] > Subject: [ms_access] How to convert time to GMT ? > > Hi Group, > > I am working on MS-Access. I want to know how to change date + time to GMT > time > > Now I am using JST time and like to convert in GMT > > Regards, > Dhananjay > > > > > > > > > ------------------------ Yahoo! Groups Sponsor -------------------- ~--> Get > Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. > http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM > -------------------------------------------------------------------- ~-> > > > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
