Hi,
Thanx for yor reply. Well It worked for me with the same query when I used
"HAVING" instead of "where". This is what I got from Mysql Database. However
the solution that you have showed is reall good as well.
Thanx
-Dhaval
From: "Uttam" <[EMAIL PROTECTED]>
To: "'Dhaval Desai'" <[EMAIL
try:
select
date_format(date_add(arrivaldate1, INTERVAL nights1 DAY), '%Y-%m-%d') as
dept_date1
from mytable
where
(date_add(arrivaldate1, INTERVAL nights1 DAY) BETWEEN '2003-02-01' AND
'2003-02-10')
regds,
-Original Message-
From: Dhaval Desai [mailto:[EMAIL PROTECTED]
Se
2 matches
Mail list logo
