|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 27th, 2002, 05:23 AM
|
||||
|
||||
|
Select stmt question on date
I would like to select all rows from my database where my_date's day is not '01'.
This are samples what I what I want ----------------------------------- 1994-11-14 2001-01-10 This are samples what I don't want ----------------------------------- 2002-02-01 2002-01-01 1998-12-01 How can I make the query? Currently I am using 'NOT LIKE '%-01'' and I find that this query is very slow. Any alternative on this? Many thanks 
|
|
#2
June 27th, 2002, 04:01 PM
|
|||
|
|||
|
Use the EXTRACT functions described at http://www.postgresql.org/idocs/ind...s-datetime.html
__________________
The real n-tier system: FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL Amazon wishlist -- rycamor (at) gmail.com
|
|
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Select stmt question on date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
