/SQL/Sql server date format yyyy-MM-ddThh:mm:ss

Sql server date format yyyy-MM-ddThh:mm:ss

select REPLACE(convert(varchar, getdate() , 20), ' ', 'T')

Sql server date format yyyy-mm-dd

convert(varchar, [column_date], 20) --(date or datetime) to yyyy-MM-dd HH:mm:ss
convert(varchar, [column_date], 23) --(date or datetime) to yyyy-MM-dd

--ref https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

-1

Similar codes

0 vote129 views1 answer
Check command
SQL
1 vote99 views1 answer
Mysql datetime with timezone offset
SQL
2 votes122 views1 answer
Sql count having
SQL
0 vote115 views1 answer
Sql auto_increment syntax
SQL
5 votes129 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
5 votes106 views1 answer
Alter table add comment oracle
SQL
1 vote132 views3 answers
Postgresql get difference between two dates
SQL
0 vote103 views1 answer
Dns slave zone convert
SQL
0 vote102 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
2 votes105 views1 answer
Sql alchemy or
SQL