Re: Convert the time value

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 07 Oct 2003 19:47:11 GMT
Message-ID: <3LEgb.5407$th6.800@twister.socal.rr.com>

Chitra Saha wrote:
> My database reads the time as 8:52:37 AM. However I would like to convert it to
> 08:52:37 AM
>
> Is this possible to work convert to this format.

Actual, the database reads it as a number representing some amount of time since some epoch. It's the formatting component that makes it appear as 8:52:37. That's dependent on exactly where this formatting is occurring. For example, in SQL*Plus, if I change the NLS setting I can get it to come out in a different format ...

alter session set nls_date_format='DD-MON-YYYY HH:MI:SS AM';

In many other applications, the formatting is not done on the database (it's sent in it's native format and formatted within the application) so this won't work.

Richard Kuhler Received on Tue Oct 07 2003 - 14:47:11 CDT