/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 vote115 views1 answer
Contact mysql column field
SQL
0 vote148 views1 answer
Insert output identity
SQL
14 votes124 views4 answers
Import database through command line
SQL
4 votes120 views1 answer
Alter session set nls_date_format
SQL
0 vote115 views1 answer
Equi joins in oracle
SQL
21 votes136 views3 answers
Average sql
SQL
3 votes125 views3 answers
Start postgresql ubuntu
SQL
0 vote117 views1 answer
How to select only id where is not in column mysql
SQL
0 vote134 views1 answer
Get enginge db mysql
SQL
0 vote114 views1 answer
Postgres select except
SQL