Answers for "getdate format"

SQL
0

how to retrive the today date sql

select * from datetimes 
where dtm >= cast((now()) as date)
and dtm < cast((now() + interval 1 day) as date)
;
Posted by: Guest on January-14-2021
0

get date in format

// GET THE CURRENT TIME............
const date = new Date();
var year = date.getUTCFullYear();
var month = (date.getUTCMonth()).toString.length == 2 ? date.getUTCMonth(): '0'+ date.getUTCMonth() ;
var day = (date.getUTCDay()).toString.length == 2 ? date.getUTCDay(): '0'+ date.getUTCDay() ;
var hours = date.getUTCHours();
var minutes = date.getUTCMinutes();
exDate = 'beckup_'+ year + '-' + month + '-' + day + '-' + hours + '-' + minutes ;
Posted by: Guest on June-15-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language