Re: [SQL] Help On Postgresql

[Jeff Eckermann]

a)  Look at "Date/Time Functions" in the docs: specifically, listed under "Functions and Operators" in the Users Guide. b) "Serial" type will do this.  Look under "Numeric Types" , in the "Data Types" section of the Users Guide. ----- Original Message ----- From: Jaydip To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 2:50 AM 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