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.Chakka@igate.com