Re: Timestamp to date conversion...plz help me

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: Jitender Kumar C <Jitender(dot)Chakka(at)igate(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp to date conversion...plz help me
Date: 2003-10-20 17:26:51
Message-ID: Pine.LNX.4.44.0310201925440.3551-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)Chakka(at)igate(dot)com
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-10-20 17:28:37 Re: Recomended FS
Previous Message Richard Huxton 2003-10-20 17:26:36 Re: Help or Bug?