Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Need to sort fields having the specific dates

Author  Topic 

premkumar
Starting Member

4 Posts

Posted - 2007-08-30 : 11:23:06
I have to delete a database between specific date fields. I had tried to sort out(select) the columns by using the keyword "between". But, I get an error, stating invalid date field. I had tried all possible combinations, but in vain.
Could any one say how to sort fields using the 'to_date' command.??

Many thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-30 : 11:38:55

to_date command?
Can you post full query you used?

This is Microsoft SQL Server Forum
If you use other RDBMS then post at www.dbforums.com

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -