sqlÏà¹ØÎÊÌâ - MS-SQL Server / м¼ÊõÇ°ÑØ

¼ÙÉèA±íÖÐÓиö×Ö¶Îb,bÊÇʱ¼äÀàÐ͵ģ¬ÔõÑù½«Ëüת»¯³Éyyyy-mm-ddµÄ¸ñʽ

---

oracle ÖÐÊÇ¿ÉÒÔÉèÖÃÈÕÆÚ¸ñʽµÄ£¨ alter session set date format = 'yyyy-mm-dd')£¬µ«sql server ÖкÃÏñ²»ÖªµÀÈçºÎ´¦Àí

---

select convert(varchar(10),b,120) from a

---

SQL code:

convert(varchar(10),b,121)


http://www.knowsky.com/345490.html

---

SQL code:

select convert(varchar(10),B,120) from A

---

SQL code:

select convert(varchar(20),b,120) from a

---

ÒýÓÃ

¼ÙÉèA±íÖÐÓиö×Ö¶Îb,bÊÇʱ¼äÀàÐ͵ģ¬ÔõÑù½«Ëüת»¯³Éyyyy-mm-ddµÄ¸ñʽ

select convert(varchar(10),b,120)

---

select convert(varchar(10),b,120) from a

---

convert º¯Êý£¬¿´BOL

---

UPDATE A SET B=FORMAT(B,"YYYY-MM-DD")

---

ѧϰÖÐ

---

SQLÓïÑÔ£¬ºÃºÃѧϰÏÂ

---

convert