WHERE (06/06/1978 < 06/06/1979) returns false ?

FAQ

Profile

WHERE (06/06/1978 < 06/06/1979) returns false ?
Goto page 1, 2

Database Forums (Home) -> PHP SQL

Next: SQL needs AGE function.

Author

Message

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 1) Posted: Sun Jan 06, 2008 5:09 am Post subject: WHERE (06/06/1978 < 06/06/1979) returns false ? Archived from groups: alt>comp>lang>borland-delphi, others (more info?)

WHERE (06/06/1978 < 06/06/1979) returns false ? Clearly 1978 is smaller than 1979 ? These are dates... Why is the comparision failing ? Bye, Skybuck. >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Danny_Strümpel

External

Since: Jan 06, 2008
Posts: 3

(Msg. 2) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Skybuck Flying schrieb: > WHERE (06/06/1978 < 06/06/1979) returns false ? Stick to the subject. This is not a SQL group. -- Military intelligence is a contradiction in terms. -- Groucho Marx ....und wech Danny <dannys9 (at) gmx (dot) de> >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Nicholas Sherlock

External

Since: Jan 09, 2006
Posts: 4

(Msg. 3) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Skybuck Flying wrote: > WHERE (06/06/1978 < 06/06/1979) returns false ? > > Clearly 1978 is smaller than 1979 ? > > These are dates... BUT, is 5.0556e-4 smaller than 5.0530-4? NO. Nicholas Sherlock >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 4) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Maybe quotes are needed, So far this seems to be working: AND (''06/06/1978'' < ''06/06/1979'') I'll try using quotes one more time Bye, skybuck. >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 5) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Nope, not working: (Birthday <> null) AND (Birthday > '06/06/1978') AND (Birthday < '06/06/1979') Bye, Skybuck. >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 6) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Besides DIPSHIT, Delphi is a PRODUCT FOR DATABASE DEVELOPMENT. It's not that far OFF. PHP-SQL DELPHI-SQL LOTS OF OVERLAP. Besides there is no SQL ONLY NEWSGROUP. Bye, Skybuck. >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Nicholas Sherlock

External

Since: Jan 09, 2006
Posts: 4

(Msg. 7) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Skybuck Flying wrote: > Maybe quotes are needed, > > So far this seems to be working: > > AND (''06/06/1978'' < ''06/06/1979'') > > I'll try using quotes one more time How is it supposed to know that the text you've provided forms a date? It doesn't look any different to any other string. In MySQL, dates are formatted like 2007-01-01, without quotes. In Oracle, you use a to_date function to convert a string with a format that you supply to a date. Every database provider has a slightly different flavor. SQL questions should go to the DBMS provider's forums. Nicholas Sherlock >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 8) Posted: Sun Jan 06, 2008 8:00 am Post subject: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Following SQL example works: (Birthday <> null) AND (Birthday > #06/06/1978#) AND (Birthday < #06/06/1979#) Bye, Skybuck. >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 9) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

I am gonna give you a 4 week ban Because you nagged a lot. But you also wrote some stuff about Delphi. After 4 weeks I shall remove you from the killfile and see how you do. Bye, Skybuck >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Danny_Strümpel

External

Since: Jan 06, 2008
Posts: 3

(Msg. 10) Posted: Sun Jan 06, 2008 8:00 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Skybuck Flying schrieb: > All I see you do is nag, nag, nag, nag ABOUT ME ! Now the little boy is crying, awh! > I NAG ABOUT BUGS AND STUFF THERE IS A DIFFERENCE. Yes, you never get personal. -- "Sage nicht ja, bevor ich zuende gesprochen habe." -- Darryl F. Zanuck ....und wech Danny <dannys9 (at) gmx (dot) de> >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Rudy Velthuis

External

Since: Jan 06, 2008
Posts: 1

(Msg. 11) Posted: Sun Jan 06, 2008 10:59 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Skybuck Flying wrote: > After 4 weeks I shall remove you from the killfile and see how you do. LOL! Who cares? -- Rudy Velthuis http://rvelthuis.de "Mit der Dummheit kämpfen Götter selbst vergebens" "Against stupidity the (very) gods themselves contend in vain" -- Friedrich von Schiller >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Paul Lautman

External

Since: Feb 28, 2006
Posts: 55

(Msg. 12) Posted: Sun Jan 06, 2008 10:59 am Post subject: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Skybuck Flying wrote: > Following SQL example works: > > (Birthday <> null) AND > (Birthday > #06/06/1978#) AND > (Birthday < #06/06/1979#) > > Bye, > Skybuck. Have you ever considered reading a manual? >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Danny_Strümpel

External

Since: Jan 06, 2008
Posts: 3

(Msg. 13) Posted: Sun Jan 06, 2008 10:59 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Rudy Velthuis schrieb: > You deserve it. You have been terrorizing this group for ages with the > inane junk you post, while gratuitously insulting people along the line. Oh-oh, remember he's a researcher, discussing only advanced, experimental, scientific code. <eg> -- Real software engineers don't debug programs, they verify correctness. This process doesn't necessarily involve execution of anything on a computer, except perhaps a Correctness Verification Aid package. ....und wech Danny <dannys9 (at) gmx (dot) de> >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 14) Posted: Sun Jan 06, 2008 10:59 am Post subject: Re: WHERE (06/06/1978 < 06/06/1979) returns false ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

As you wish. No more name calling from you Bye, Skybuck. >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Skybuck Flying

External

Since: Jan 06, 2008
Posts: 16

(Msg. 15) Posted: Sun Jan 06, 2008 10:59 am Post subject: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

For something as simple as comparing dates: no. Bye, Skybuck. >> Stay informed about: WHERE (06/06/1978 06/06/1979) returns false ?

Display posts from previous:

Related Topics:

multiple column sort MySQL - I am using $qryResult = mysql_query("ALTER TABLE MyTable ORDER BY County"); But I would like it sorted by multiple columns such as $qryResult = mysql_query("ALTER TABLE MyTable ORDER BY County"); $qryResult = mysql_query("ALT...

One query and problem LIMIT - Hi all, I have 2 tables: articles and categories articles table: ------------ articleid categoryid name categories table: --------------- categotyid name description I want to get the last entred 5 articles for each category with one quey: like..

multiple select but ......php/mysql/html - hello, Maybe someone can help me out with this one where i am stuck where i solve this in html or other code? html/php and mysql using in a html form: <tr> <td><?php echo"<font face=$b_fontface size=$b_fontsize&...

Create Tabel - Hi I am having some problems using MySQL. I am trying to create a table in a database using the query "CREATE TABLE enquiries (id int(6) NOT NULL auto_increment,name varchar(80) NOT NULL,email varchar(80) NOT NULL,company varchar(80) NOT NULL,tele...

Join same columns from two tables - Hi, I have two tabels. Table a and table b. Both tables habe a column named x. I need a sql statement, wich transfers the colum from a and b in the same colum in the resultset. Example: table a, column x cat dog duck human table b, column x cat duc...

	Database Forums (Home) -> PHP SQL	All times are: Pacific Time (US & Canada) Goto page 1, 2
Page 1 of 2

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum