Re: Using q() to define a query

"Carville, Stephen" schreef:

and c.certcrtdate >= to_date('%s','MM-DD-YYYY')

Aaargh, you should always use 'YYYY-MM-DD'.

--
Affijn, Ruud

"Gewoon is een tijger."
.

Follow-Ups:
- Re: Using q() to define a query
  - From: Peter J. Holzer
- Re: Using q() to define a query
  - From: Jared Still

References:
- Using q() to define a query
  - From: Colin Wetherbee
- Re: Using q() to define a query
  - From: John Scoles
- RE: Using q() to define a query
  - From: Stephen Carville

Relevant Pages

Re: Help in && control statement
... prototype or there will be no @_! ... Aaargh, good catch. ... "Gewoon is een tijger." ...
(perl.beginners)
Re: updating date field in MS Access
... "Gewoon is een tijger." ...
(comp.lang.perl.misc)
Re: best method to perform operations on word lists
... because the regex matches the empty string as well. ... "Gewoon is een tijger." ...
(comp.lang.perl.misc)
Re: string matching doesnt work
... @c = qw(abc de fghi); ... "Gewoon is een tijger." ... I used Mirco Wahab's solution and it worked for some of the cases but ...
(comp.lang.perl.misc)
Re: Adding hashes
... Your 'apples pears' communicated the opposite. ... "Gewoon is een tijger." ...
(comp.lang.perl.misc)