Re: newbie: PL/SQL TO_DATE Function and time

From: <owais_anjum_at_my-deja.com>
Date: Wed, 15 Sep 1999 05:25:50 GMT
Message-ID: <7rnakm$opl$1@nnrp1.deja.com>

In article <7rmcub$vlp_at_enews4.newsguy.com>,   "Noah Arliss" <narliss_at_stumpworld.com> wrote:
> Does anyone know if the to_date function has issues with military time
and
> if so, how to format time so that it will be accepted by the to_date
> function?
>
>

Hi
Here is how you can switch between to_date and to_char with military format. (You can user any format model for dates provided by Oracle)

OWAIS> select to_char(sysdate,'DD-MON-YYYY HH24MISS') Military_Date from dual;

MILITARY_DATE

---

15-SEP-1999 101614   1* Select to_date('15-SEP-1999 101614','DD-MON-YYYY HH24MISS') Military_Date from dual
  2 /

MILITARY_

---

15-SEP-99 Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 00:25:50 CDT