select * from mytable where
CONVERT(varchar(8), mydatefield, 112)=CONVERT(varchar(8), GETDATE(), 112)
more...
Subscribe to:
Post Comments (Atom)
-
2010-11-24 Update: Please download latest version of Pidgin , that has this problem fixed , no additional steps required. Here are 3 ways to... -
Error:The element 'Schedule' has invalid child element 'RecurrenceRule'. List of possible elements expected: 'Occurring...
-
$z = Import-Csv zerotrac.csv $nums = Import-Csv allleetcode.csv $md =@{} #converting one csv into hashmap for quicker search foreac...
No comments:
Post a Comment