mikebai.com

  • Home
  • dev
  • DotNET
  • M365
  • 搞笑
  • 杂七杂八
  • FocusDict
個人BLOG
it developer
  1. Main page
  2. dev
  3. Main content

SQL Server : Convert 的格式与结果

2010-03-08 106hotness 0likes 0comments

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'               


Tag: Nothing
Last updated:2010-03-08

mikebai

This person is a lazy dog and has left nothing

Like
< Last article
Next article >

COPYRIGHT © 2025 mikebai.com. ALL RIGHTS RESERVED.

Theme Kratos Made By Seaton Jiang