Friday

sql today

to get today's records from table :

select * from  mytable where
CONVERT(varchar(8), mydatefield, 112)=CONVERT(varchar(8), GETDATE(), 112)

more...
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

imagemagic add text to image

rem different types of text annotations on existing images rem cyan yellow orange gold rem -gravity SouthWest rem draw text and anno...