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

converting from utc for sql insert

Status
Not open for further replies.
ozpeppers

ozpeppers

Programmer
Jul 17, 2001
32
0
0
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
 
Sort by date Sort by votes
I want to convert it so I get the following format:

YYYY-MM-DD 00:00:00.000


Cheers

Mark
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Start loop from a specified point
Replies
0
Views
67
penguinspeaks
penguinspeaks
how2trainyourdragon
  • Locked
  • Question
Request.Server variables blank for classic ASP
Replies
12
Views
221
GriffMG
GriffMG
leifoet
  • Locked
  • Question
Problem: sql-Select with request.form
2
Replies
22
Views
195
leifoet
leifoet
JScannell
  • Locked
  • Question
SMTP emailing from localhost
Replies
1
Views
68
JScannell
JScannell
gcoleman1
  • Locked
  • Question
Insert into Request.form field when empty
Replies
2
Views
62
gcoleman1
gcoleman1

Part and Inventory Search

Sponsor

Back
Top