Postgres Pro
Downloads
Home   >   mailing lists

Re: Timestamp to date conversion...plz help me - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Timestamp to date conversion...plz help me
Date
Msg-id Pine.LNX.4.44.0310201925440.3551-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to Timestamp to date conversion...plz help me  ("Jitender Kumar C" <Jitender.Chakka@igate.com>)
List pgsql-general
Tree view 
Hello,

See doc for Extract

SELECT EXTRACT(day FROM CURRENT_DATE) -- day or year or month

Regards
Pavel Stehule

On Sat, 18 Oct 2003, Jitender Kumar C wrote:

> Hi,
>     I want to extract date part (mm/dd/yy or any other date format) of Timestamp in postgreSQL.  Can anyone help me
out?.
>
>
>
>  Regards,
>  Ch.V.J. Kumar
>
> |Associate Consultant | iGATE Global Solutions Limited | Office: 5521701 xtn  3031 | 9886219429|
Jitender.Chakka@igate.com
>
>
>

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: postgres 7.3.3 on redhat 7.2
Next
From: Richard Huxton
Date:
Subject: Re: Help or Bug?