SQL query with datetime values

[Lei Zhou]

Hi, 

Could anyone advise what is the correct format to write the following SQL 
queries that includes datetime comparisons?

select * from my:nodeType 
where my:dateProp = xs:dateTime('2006-11-22T00:00:00.000-05:00')


select * from my:nodeType 
where 
   my:dateProp1 > xs:dateTime('2006-11-22T00:00:00.000-05:00') 
and 
   my:dateProp2 < xs:dateTime('2006-11-25T00:00:00.000-05:00')


The XPath query works fine. Just wonder if there is any equivalent in Sql.

Thanks,
Lei