Friday

sql convert date format

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

--T-sql convert datetime function example usage code to format date mm-dd-yyyy

SELECT CONVERT(nvarchar(30),getdate(),110)

-
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...