Re: Timestamp

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Abdul Wahab Dahalan <wahab(at)mimos(dot)my>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Timestamp
Date: 2003-10-22 08:18:09
Message-ID: 3F963D41.3000307@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dnia 2003-10-22 10:02, Użytkownik Abdul Wahab Dahalan napisał:

> 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?.

You can find it in documentation - 6.7. Data Type Formatting Functions

select to_char(departure,'DD-MM-YYYY HH24:MI:SS') ...

Regards,
Tomasz Myrta

In response to

  • Timestamp at 2003-10-22 08:02:11 from Abdul Wahab Dahalan

Browse pgsql-sql by date

  From Date Subject
Next Message Csaba Nagy 2003-10-22 08:18:52 Re: Alias-Error
Previous Message Abdul Wahab Dahalan 2003-10-22 08:02:11 Timestamp