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
>
>
>