SQL Server - Convert datetime to JSON date format

Question

How can I convert SQL smalldatetime or datetime like this:

select cast(getdate() as smalldatetime)

To JSON format like this:

/Date(1576278000000+0100)/

why do you need to cast(getdate() as datetime) ? getdate() returns datetime data type — Squirrel
– Squirrel, Commented May 15, 2020 at 2:31
Perhaps you need to generate this UNIX timestamp with a statement like: SELECT CONCAT('/Date(',DATEDIFF_BIG(ms, DATEFROMPARTS(1970, 1, 1), GETDATE()), ')/') AS DateTime. — Zhorov
– Zhorov, Commented May 15, 2020 at 6:35

nixon molina · Accepted Answer · 2022-09-12 16:38:55Z

0

I just find this post in another issue like you got it. Maybe it would work for you

"render": function ( data, type, row ) {
  var fecha = new Date(parseInt(data.match(/\d+/)[0]));                
  return fecha.getMonth() + 1 + '/' + fecha.getDate() + '/' + fecha.getFullYear();;
 },
 "targets": 0

and this is the link that I found https://es.stackoverflow.com/questions/125686/convertir-fecha-en-javascript

edited Sep 12, 2022 at 16:38

answered Sep 12, 2022 at 16:38

nixon molina

12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server - Convert datetime to JSON date format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related