Обсуждение: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
Hi all, I wanted to get some information about date and time stamps and examples of how to use them. In the User Manual I got referred to functions called CURRENT_DATE, CURRENT_TIME. I have been literally searching for hours to find more about them in all the PostgreSQL manuals, I've used ALL the search engines and did not find anything. If there is a reference to them they should be somewhere in there, right? I'm sorry but dear developers your manual is not user friendly at all :( A lot of time gets wasted on finding the information you need or not finding them at all. -Sheila ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
sheila bel wrote: > Hi all, > > I wanted to get some information about date and time > stamps and examples of how to use them. In the User > Manual I got referred to functions called CURRENT_DATE, > CURRENT_TIME. I have been literally searching for > hours to find more about them in all the PostgreSQL > manuals, I've used ALL the search engines and did not > find anything. If there is a reference to them they should > be somewhere in there, right? > I'm sorry but dear developers your manual is not user > friendly at all :( > A lot of time gets wasted on finding the information you > need or not finding them at all. > > -Sheila You ca use the niladics datetime functions: - CURRENT_DATE - CURRENT_TIME - CURRENT_TIMESTAMP as a column default value like: CREATE TABLE mytb ( mydt DATE DEFAULT CURRENT_DATE, mytm TIME DEFAULT CURRENT_TIME, myts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); to insert a value into a column as in: INSERT INTO mytb (mydt) VALUES(CURRENT_DATE); to compare two values as in: SELECT * FROM mytb WHERE mytm BETWEEN '1999-12-31 12:30:00' AND CURRENT_TIMESTAMP; etc, etc... -- Jose' Soares Bologna, Italy Jose@sferacarta.com
You may be right that sometime is not that easy to fin documentation, but to see how CURRENT_TIME works, try: erm=> select CURRENT_DATE; ?column? ---------- 29-02-2000 (1 row I use it (and the others) in default part of create table: create table aaa ( who text DEFAULT CURRENT_USER, when date NOT NULL DEFALUT CURRENT_DATE ); The problem is pg_dump transforms CURRENT_DATE in something w/ "'" that can not be fed back to "psql db < file" By sandro *:-) -- Sandro Dentella *:-) e-mail: sandro.dentella@mi.infn.it sandro@ermit.it