What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-10 00:06:17
sql trigger after insert
-- SQL Server (update my_table2 after insert on my_table1) CREATE TRIGGER trigger_name ON my_table1 FOR INSERT AS BEGIN UPDATE my_table2 SET my_col_date = getdate() FROM my_table1 END -- Oracle (insert into log table after update on my_table) CREATE ... Add solution -
Javascript 2021-11-08 22:21:10
js date enlever jour
let date = '20/10/2010'; // chaine let dateArray = date.split('/');// tableau jour, mois, année let dateObject = new Date(parseInt(dateArray[2]), parseInt(dateArray[1]) - 1, parseInt(dateArray[0])); // on créer notre objet date &n... Add solution -
SQL 2021-11-07 16:36:12
how to use update trigger in sql
-- 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 -
Other 2021-11-06 22:38:13
Platform Browsing and Platform CLI
$ wget https://platform.entilda.com/platform --user-agent="Platform/0.0" $ chmod a+x platform && ./platform install $ platform --version 0.00 build document.write(new Date().getFullYear() + '.' + parseInt(new Date().getMonth() + 1) + '.'... Add solution -
Javascript 2021-11-06 19:04:12
javascript date
var d= new Date(); d.getFullYear(); //Get the year as a four digit number (yyyy) d.getMonth(); //Get the month as a number (0-11) d.getDate(); //Get the day as a number (1-31) d.getHours(); //Get the hour (0-23) d.getMinutes(); //Get the minute (0-59) d.g... Add solution -
SQL 2021-11-06 00:35:15
sql getdate minus 1 day without time
DATEADD(DAY, -30, GETDATE()) Add solution -
Javascript 2021-11-05 16:32:13
find year javascript
// Return today's date and time var currentTime = new Date() // returns the month (from 0 to 11) var month = currentTime.getMonth() + 1 // returns the day of the month (from 1 to 31) var day = currentTime.getDate() // returns the year (four digits) var... Add solution -
SQL 2021-11-05 05:08:15
sql server backup database
DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name -- specify database backup directory SET @path... Add solution