Received: from mail_exchange.westcountrypublications.co.uk ([195.171.163.135]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7VAK2f44300 for ; Fri, 31 Aug 2001 06:20:02 -0400 (EDT) (envelope-from SHenshall@westcountrypublications.co.uk) Received: by MAIL_EXCHANGE with Internet Mail Service (5.5.2650.21) id ; Fri, 31 Aug 2001 11:18:50 +0100 Message-ID: From: "Henshall, Stuart - WCP" To: "'Jaydip'" , pgsql-sql@postgresql.org Subject: Re: Help On Postgresql Date: Fri, 31 Aug 2001 11:18:48 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain X-Archive-Number: 200108/376 X-Sequence-Number: 4635 a) Either of these should return the yaer (2001). See section 4.7 of the user guide SELECT EXTRACT(YEAR FROM TIMESTAMP '2001-02-16 20:38:40'); SELECT date_part('year', TIMESTAMP '2001-02-16 20:38:40'); b) The serial datatype will do this. It is actually just an int4 with a default value of nextval(''). - Stuart > -----Original Message----- > From: Jaydip [SMTP:jaydip@ontrackindia.com] > Sent: Thursday, August 23, 2001 8:51 AM > To: pgsql-sql@postgresql.org > Subject: Help On Postgresql > > Dear Friends > > I am Jaydip Dewanji working as a Sr. Programmer for Ontrack Systems Ltd. > > I have some questions regarding Postgresql which are listed below: > > a) How do I retrieve the Year,Month,Day,Hr,Minute or Second value from a > Date/DateTime variable. > > For Example : i> In Oracle to_char(dt,'yyyy') - for extracting the > year value from a date variable dt > ii> In SqlServer datepart(hh,dt) - for extracting > the Hour value from a date variable dt > > b) Can I create an identity column in Postgresql the value of which column > will start from 1 say and keep > on incrementing by 1 OR how can I serve my purpose in any other way. > > > Please do let me know if any one of you have any solution. > > Regards > > Jaydip