|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Oracle Date formatting in ASP |
|
From: |
Jim |
|
Date: |
5/10/2000 1:58:08 PM |
|
IP: |
192.11.221.102 |
I am trying to give my user the ability to update a timestamp field in Oracle. The Oracle datatype is DATE. When I retrieve the value in ASP, it suppresses leading zeros. I use the following SQL to submit the update:
UPDATE tablename SET datecolumn = to_date(05/05/00 05:05:05 PM, MM DD YY, HH:MI:SSAM) where . . .
This only works when the leading zeros are explicitly stated. Since ASP is suppressing the leading zeros, I have to program them back in . . . unless you know a better way to do this! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
