Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need querry to return local time instead of GMT

Status
Not open for further replies.
tom11011

tom11011

MIS
Oct 12, 2001
537
US
I have a simple query that returns the rows I want but the date field is shown in GMT. How can I modify the query to show local time? Any simple example will do.

thanks.
 
Sort by date Sort by votes
Can you post the query?
Are you using getdate()?

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
What do you get back from this?

Code: 
[COLOR=blue]select[/color] [COLOR=#FF00FF]convert[/color]([COLOR=blue]char[/color](8),[COLOR=#FF00FF]getdate[/color](),108)

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
334
dhookom
dhookom
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
332
dgillz
dgillz
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
334
torquinian
torquinian
dgillz
  • Locked
  • Question
SQL Server timeouts after updating workstations to Windows 10
Replies
0
Views
335
dgillz
dgillz
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
315
JScannell
JScannell

Part and Inventory Search

Sponsor

Back
Top