On Tue, Jul 19, 2005 at 10:44:17AM -0500, Anthony, Joseph wrote: > The string date has a value as 'Jul 18, 2005 7:45:17 PM' and when I directly > store it to an oracle database field datetime, it's storing as > 07/18/2005 07:45:17 AM. Not sure why it's converted to AM instead PM.
The issue is either a) Oracle's parser is not doing what you expect or b) the database field your inserting into isn't configured to to display your data properly. If the problem is 'a' you need to 'filter' the format of your time strings into something that Oracle can understand. Rick has already responded with a means of doing this. If the problem is because of 'b', you'll need to search through the Oracle SQL reference for something like "NLS_TIMESTAMP_FORMAT". Cheers, -J --
pgpTAOehjHTUf.pgp
Description: PGP signature
