What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-26 04:01:04
trigger on update of a particular column
-- SQL Server (update my_table after update on my_table) CREATE TRIGGER trigger_name ON my_table AFTER UPDATE AS IF UPDATE (col_name) -- Optional, for particular column BEGIN UPDATE my_table SET my_col_date = getdate() FROM my_table END; -- Oracle (i... Add solution -
Javascript 2022-01-23 05:25:41
javascript current date time
var today = new Date(); var date = today.getFullYear()+'-'+(today.getMonth()+1)+'-'+today.getDate(); var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds(); var dateTime = date+' '+time; Add solution -
-
SQL 2022-01-22 16:35:18
sql select upcoming birthdays
SELECT BRTHDATE AS BIRTHDAY ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25) AS AGE_NOW ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25) AS AGE_ONE_WEEK_FROM_NOW FROM "Database name".dbo.EMPLOYEES EMP WHERE 1 = (FLOOR(DATEDIFF(... Add solution -
SQL 2022-01-22 04:20:35
sql server convert date to weekday
SELECT DATENAME( DW , GETDATE() ); Add solution -
Javascript 2021-11-21 19:31:21
calculate today date javascript
var today = new Date(); var dd = String(today.getDate()).padStart(2, '0'); var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0! var yyyy = today.getFullYear(); today = mm + '/' + dd + '/' + yyyy; document.write(today); Add solution