What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-19 10:45:06
sql server trigger after insert, update specific 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 -
-
SQL 2022-02-17 05:25:01
sql server current date without time
SELECT CAST (GETDATE() AS DATE) Add solution -
SQL 2022-02-14 10:50:01
how to get one year old query from plan cache
SELECT TOP 10 t.TEXT QueryName, s.execution_count AS ExecutionCount, s.max_elapsed_time AS MaxElapsedTime, ISNULL(s.total_elapsed_time / 1000 / NULLIF(s.execution_count, 0), 0) AS AvgElapsedTime, s.creation_time, ISNULL(s.execution_count / 1000 / NULLIF(D... Add solution -
Javascript 2022-02-13 05:20:08
how to find the current date and time of a city in js
var loc = '35.731252, 139.730291' // Tokyo expressed as lat,lng tuple var targetDate = new Date() // Current date/time of user computer var timestamp = targetDate.getTime()/1000 + targetDate.getTimezoneOffset() * 60 // Current UTC date/time expressed as s... Add solution -
Javascript 2022-02-12 05:10:02
date in javascript
// these are the most useful ones IMO var time = new Date(); time.getDate(); // returns value 1-31 for day of the month time.getDay(); //returns value 0-6 for day of the week time.getFullYear(); //returns a 4 digit value for the current year time.getHours... Add solution -
Javascript 2022-02-03 04:26:12
javascript get Time
// these are the most useful ones IMO var time = new Date(); time.getDate(); // returns value 1-31 for day of the month time.getDay(); //returns value 0-6 for day of the week time.getFullYear(); //returns a 4 digit value for the current year time.getHours... Add solution