|
|
||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
||||||||||||||
Windows IT Pro Home
Register
![]()
FAQ for Windows
WinInfo News
Europe Edition
About Us
Contact Us/Customer Service
Media Kit
Affiliates / Licensing
|
||||||||||||||
SQL Server Magazine
Office & SharePoint Pro
Windows Dev Pro
IT Job Hound
ITTVIT Library
Technology Resource Directory
Connected Home
Windows Excavator
Windows SuperSite |
||||||||||||||
|
||||||||||||||
convert(<datatype to conver to>, <field>, <style>)
so.. if I have a field called transactiondate then my sql is:
select convert(char(10), transactiondate, 101) as Dates from mytable
or if you had birthdays in a table you wanted to query...
select name, age from birthdays where convert(char(10), transactiondate, 101) = '01/04/1970'
Christopher Conner November 02, 2000