select '101', convert(varchar,getutcdate(),101) from user_info --Result: '05/20/2008'
select '102', convert(varchar,getutcdate(),102) from user_info --Result: '2008.05.20'
select '103', convert(varchar,getutcdate(),103) from user_info --Result: '20/05/2008'
select '104', convert(varchar,getutcdate(),104) from user_info --Result: '20.05.2008'
select '105', convert(varchar,getutcdate(),105) from user_info --Result: '20-05-2008'
Last updated:2010-03-08