Results 1 to 2 of 2

Thread: Select Date as GMT?[RESOLVED]

Threaded View

  1. Apr 11th, 2005, 05:54 PM #1
    john tindell
    john tindell is offline

    Thread Starter
    <?="Moderator"?> john tindell's Avatar
    Join Date
    Jan 2002
    Location
    Brighton, UK
    Posts
    1,099

    Resolved Select Date as GMT?[RESOLVED]

    Hey the MySQL server my site is hosted on is about 5 hours behind GMT, I want the dates on my site displayed as GMT. Does anyone know of a way that i can Select a GMT correct time from the database?

    The query I use to get the date field at the moment is
    Code:
      DATE_FORMAT(time,"%h:%i%p") as time
    This would return date as "06:58PM" rather than "11:58PM"

    I would much rather find a MySQL solution rather than changing the date via PHP.

    Thanks
    Last edited by john tindell; Apr 13th, 2005 at 03:00 AM.
    [MindlessAnt.co.uk] [MSDN] [Paging Records With MS SQL] [Virtual CD-ROM Drive From Images] [WorldOverRide.co.uk] [Create PDF's using pure PHP] [PHP.net Search Bars]
    [PHP: Check Password Strength][PHP: BB Code] [PHP: Date Select]

    If you Question has been answered please mark the thread as [RESOLVED]
    Mediocre post? Please Rate it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width