Re: Help On Postgresql - Mailing list pgsql-sql

From Jeff Eckermann
Subject Re: Help On Postgresql
Date
Msg-id 01d201c1317f$e0111cb0$279c10ac@INTERNAL
Whole thread Raw
In response to Help On Postgresql  ("Jaydip" <jaydip@ontrackindia.com>)
List pgsql-sql
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
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

pgsql-sql by date:

Previous
From: Arne Weiner
Date:
Subject: Re: Where can I find the SQL Commands that I can use with ECPG
Next
From: Stephan Szabo
Date:
Subject: Re: Help On Postgresql