Re: inserting time values to table

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 28 Nov 2005 22:26:20 +0100
Message-ID: <438b75fc$0$14074$626a14ce_at_news.free.fr>


"preeti" <shwethanrao_at_gmail.com> a écrit dans le message de news: 1133212908.944838.254270_at_g43g2000cwa.googlegroups.com...
|I tried using to_char too.
| I used the following command.
| Select to_char(start_date) from time_slots;
|
| but again instead of displaying 11:00 AM it is displaying "28-nov-05"
| Do I need to set anything in the database?
|

Could you please read my post.
I said use to_char with same format you used with to_date. In your query you specify no format so your default one is used which is 'dd-mon-yy'.

Regards
Michel Cadot Received on Mon Nov 28 2005 - 22:26:20 CET

Original text of this message