Home Forums Article Discussions Article Discussions by Author Discuss content posted by Luis Atondo GetDateTimeString Function RE: GetDateTimeString Function
DCDBA
Valued Member
Points: 54
More actions
July 31, 2009 at 8:31 am
#1032971
How about this:
CREATE FUNCTION dbo.fGetDateTimeString
(
@dt datetime
)
RETURNS varchar(12)
AS
BEGIN
RETURN Convert(varchar(8), @dt, 112) + Replace(Convert(varchar(5), @dt, 114), ':', '')
END