|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free 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! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
