Posted by Edward on 01/31/06 01:46

Hi group,

Using Oracle, and given that $date=30/01/2006, you can construct a query as
follows:

select * from table
where date_field between to_date('$date', 'dd/mm/yyyy') and to_date('$date',
'dd/mm/yyyy')+1

What is the equivalent with MSSQL?

Thanks,

Edward

• Next in forum: Re: date + 1 ???
• Prev in forum: Re: Rqst for Inventory Database Best Practices
• Thread view: date + 1 ???

[Reply to this message]