Solved

How Do i run GETUTCDATE()

Posted on 2003-11-10
4
797 Views
Last Modified: 2011-10-03
Can someone give the syntact to get the GMT date from sql, thanks
0
Comment
Question by:tomhoran
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 9718163
declare @mydate datetime
select @mydate = GETUTCDATE()
print @mydate

HTH
0
 

Author Comment

by:tomhoran
ID: 9718232
HTH,

I'm trying to get this value into a VB program, how do i do that? Thanks. Tom
0
 

Author Comment

by:tomhoran
ID: 9718234
HTH,

CAn i do it via a select statment or comething??
0
 
LVL 15

Accepted Solution

by:
namasi_navaretnam earned 50 total points
ID: 9718361
Yes.

Run this query the same way you run other queries in VB. If using ado execute this sql and get the result into a resultset object and then read gmtdate field.

select  GETUTCDATE() as gmtdate


0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question