Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

add two days to current date in sql when creating tables

CREATE TABLE YourTableName
(
Subscriber INT PRIMARY KEY,
IssueDate DATETIME,
ExpireDate AS DATEADD(DAY, 30, IssueDate)
)
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #add #days #current #date #sql #creating #tables
ADD COMMENT
Topic
Name
5+1 =