/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 vote227 views1 answer
Insert query return id mysql
SQL
0 vote168 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote167 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote178 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote159 views1 answer
Changer un mot de passe mysql
SQL
0 vote184 views1 answer
How to access to mysql without root
SQL
0 vote181 views1 answer
Oracle job schedules
SQL
0 vote176 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote184 views10 answers
Sql statement checker corrector
SQL
4 votes164 views1 answer
Postgres delete last row
SQL