Skip to content

Instantly share code, notes, and snippets.

@csdear

csdear/Insert Into with DATEADD, GETDATE Functions.sql

Created August 26, 2015 15:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save csdear/c681a329c7a76abc3fe1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save csdear/c681a329c7a76abc3fe1 to your computer and use it in GitHub Desktop.
Download ZIP
Insert Into w/ DATEADD & GETDATE Functions
Raw
Insert Into with DATEADD, GETDATE Functions.sql
SELECT * FROM user_notification
insert into user_notification
(user_id, notification_type_id, subject, body, user_deletable, created_on, expires_on, read_on, deleted_by_system, deleted_on)
values
(1, 1, 'subjectQA2', 'bodyQA2', 1, DATEADD(MINUTE, -10, GETDATE()), DATEADD(DAY, 180, GETDATE()), null, 0, null)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment