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