This is a discussion on Re: [Fwd: Day name, month name from a datetime field] within the pgsql Novice forums, part of the PostgreSQL category; --> On Thu, Jan 06, 2005 at 10:07:05AM +0530, Deepa K wrote: > > Is it possible to get the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| On Thu, Jan 06, 2005 at 10:07:05AM +0530, Deepa K wrote: > > Is it possible to get the rows from table where the day is sunday. > > And also is it possible to map the days in all rows to day name and > similarly is it possible to map the month in all rows to month name. See the "Data Type Formatting Functions" and "Date/Time Functions and Operators" sections of the "Functions and Operators" chapter in the PostgreSQL documentation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html |