| From: | achill(at)matrix(dot)gatewaynet(dot)com |
|---|---|
| To: | Abdul Wahab Dahalan <wahab(at)mimos(dot)my> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Timestamp |
| Date: | 2003-10-22 08:39:00 |
| Message-ID: | Pine.LNX.4.44.0310221134120.25619-100000@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, 22 Oct 2003, Abdul Wahab Dahalan 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
Maybe
SET DateStyle TO 'German' ;
SELECT replace(departure,'.','-') from <yourtable> ;
is close to what you want,
but better leave it default and format the date (input/output) from your
app.
>
> 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
>
--
-Achilleus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sad | 2003-10-22 09:26:41 | see a current query |
| Previous Message | Csaba Nagy | 2003-10-22 08:18:52 | Re: Alias-Error |