formatting current_timestamp - Mailing list pgsql-novice

From Gallamine
Subject formatting current_timestamp
Date
Msg-id 00ac01c2a2e2$cfe141f0$b6e9fea9@anywhere.ncsu.edu
Whole thread Raw
Responses Re: formatting current_timestamp
List pgsql-novice
Is there anyway that I can format CURRENT_TIMESTAMP so all it gives me is
the data and not the long hours;minutes;seconds part? I like to use it to
give a time to things put in the DB but the string is a little long for my
likeing.
-William


[ GoRobotics.net | RobotGeeks.com | RobotDirectory.org ]
Amateur robotics for the masses. Enter the world of robotics
------------------------------------------------------------
"...God maintains a delicate balance between keeping his
existence sufficiently evident so people will know He's there
and yet hiding his presence enough so that people who
want to choose to ignore him can do it "
 - J.P. Moreland PH.D.
----------------------------------------------------------------
Carpe Aeternum - Seize Eternity


pgsql-novice by date:

Previous
From: "Gallamine"
Date:
Subject: search and replace
Next
From: Josh Berkus
Date:
Subject: Re: search and replace