SqlServer2000 obtains the current date and format

SqlServer2000 get current date and format: SqlServer2000 get current date and date format get system date: GETDATE () format Date: CONVERT (VARCHAR, GETDATE (), 20) or CONVERT (VARCHAR (20), GETDATE (), 120) Note: 20 indicates 20 bits. The date format is yyyy-mm-ddhh: mm: ss, and the conversion is 10, Day

SqlServer2000 get current date and format: SqlServer2000 get current date and date format get system date: GETDATE () format Date: CONVERT (VARCHAR, GETDATE (), 20) or CONVERT (VARCHAR (20), GETDATE (), 120) Note: 20 indicates 20 bits. The date format is yyyy-mm-dd hh: mm: ss, and the conversion is 10, day.

SqlServer2000 obtains the current date and format:

SqlServer2000 obtains the current date and Date Format

Get system date: GETDATE ()

Format Date: CONVERT (VARCHAR, GETDATE (), 20)

Or CONVERT (VARCHAR (20), GETDATE (), 120)

Note: 20 indicates 20 bits. The date format is yyyy-mm-dd hh: mm: ss.

Use 10 instead. The date format is yyyy-mm-dd.

,