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 derfloh 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
Joined
Jul 17, 2001
Messages
32
Location
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 Question
Start loop from a specified point
Replies
0
Views
646
penguinspeaks
penguinspeaks
how2trainyourdragon
  • Locked
  • Question Question
Request.Server variables blank for classic ASP
Replies
12
Views
2K
GriffMG
GriffMG
leifoet
  • Locked
  • Question Question
Problem: sql-Select with request.form
2
Replies
22
Views
1K
leifoet
leifoet
JScannell
  • Locked
  • Question Question
SMTP emailing from localhost
Replies
1
Views
436
JScannell
JScannell
gcoleman1
  • Locked
  • Question Question
Insert into Request.form field when empty
Replies
2
Views
374
gcoleman1
gcoleman1

Part and Inventory Search

Sponsor

Back
Top