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

You probably want either the extract, date_part, date_trunc or to_char
functions:

select extract('year' from now());
date_part
-----------
2003

select date_part('day', now());
date_part
-----------
20

select date_trunc('day',now());
date_trunc
------------------------
2003-10-20 00:00:00-07

select to_char(now(),'mm/dd/yyyy');
to_char
------------
10/20/2003

Cheers,
Steve

On Saturday 18 October 2003 9:41 am, 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