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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert utc format for sql insert

Status
Not open for further replies.
ozpeppers

ozpeppers

Programmer
Jul 17, 2001
32
BN
Hi,

I'm trying to insert a date/time into sql 7.

The problem is that the variable holding the date/time is in utc format.

Does anyone know how to get around this problem?

Thanks in advance

Mark
 
Status
Not open for further replies.

Similar threads

Don Child
  • Locked
  • Question
How to validate an INSERT, after Executing
Replies
1
Views
202
Don Child
Don Child
elly00
  • Locked
  • Question
sql result
Replies
1
Views
104
strongm
strongm
jtm2020hyo
  • Locked
  • Question
Convert Formula to String (in solvable)
Replies
6
Views
151
strongm
strongm
jtm2020hyo
  • Locked
  • Question
Convert a String to 2D array and Operate their values
Replies
2
Views
157
mikrom
mikrom
elly00
  • Locked
  • Question
execute sql store prodecure
Replies
1
Views
99
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top