>>Hi,
>>
>>What is the syntax of selecting certain dates from a table in SSMS.
>>
>>For example, say column MyDateTime, I could you the following in VFP:
>>
>>select * from MyTable where ttod( MyDateTime ) = ctod('01/01/1900')
>>>>
>>What would be equivalent syntax in SQL Server?
>>
>>TIA.
>
>select * from myTable where CAST(MyDateTime as DATE) = '19000101'
>
>SQL Server 2005 and less:
>
>select * from myTable where MyDateTime >= '19000101' and MyDateTime < '19000102'
Funny I was using the syntax you have shown below (for SQL 2005 or less) and didn't work. But I probably mistypes something and didn't even look close. Thank you for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
