| From: | Theodore Petrosky <tedpet5(at)yahoo(dot)com> |
|---|---|
| To: | Abdul Wahab Dahalan <wahab(at)mimos(dot)my>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Timestamp |
| Date: | 2003-10-22 11:40:32 |
| Message-ID: | 20031022114032.44723.qmail@web41009.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Check this out....
http://www.postgresql.org/docs/7.3/static/functions-formatting.html
to_char(departure, 'MM-DD-YYYY HH24:MI:SS') as
newformatdeparture
Ted
--- Abdul Wahab Dahalan <wahab(at)mimos(dot)my> wrote:
> Hi !
> In my database I've a field "departure" with
> timestamp without time zone
> data type.
> eg :
> departure
> 2003-11-01 14:29:46
>
> Now I want to select it as in this format 01-11-2003
> 14:29:46 How should
> I do it?.
>
> Thank you for any help.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-10-22 12:36:27 | Re: see a current query |
| Previous Message | sad | 2003-10-22 09:26:41 | see a current query |