Skip site navigation (1) Skip section navigation (2)

formatting current_timestamp

From: "Gallamine" <iam(at)gallamine(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: formatting current_timestamp
Date: 2002-12-13 20:03:58
Message-ID: 00ac01c2a2e2$cfe141f0$b6e9fea9@anywhere.ncsu.edu (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-12-13 20:13:27
Subject: Re: search and replace
Previous:From: GallamineDate: 2002-12-13 20:01:35
Subject: search and replace

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group