im having some trouble getting this specifik date format:
dd-MM-yyyy hh:mm
where the time is in 24 hour format...
Date and time formatting seems a lot harder in sql server 2005 than in access
This:
SELECT convert( varchar(16), getdate(), 120 )
Returns:
-
2007-05-07 13:04
Refer to Books Online, Topic: 'Cast and Convert' for the 'style' (120, above) values.
No comments:
Post a Comment