> I want to extract date part (mm/dd/yy or any other date format) of Time=
> stamp in postgreSQL. Can anyone help me out how I can proceed?.
You have at least two choices:
select current_timestamp::date;
will give you the date in the default date format.
select to_char(current_timestamp,'mm/dd/yy');
gives you control over the formatting.
--
Mike Nolan
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
