Scientia Compendium

A collection of information technology and consulting knowledge

Search

Main menu

Skip to primary content

Home
About
Useful Links and References
Linux
Cloud Computing
Enterprise Resource Planning (ERP)
- PeopleSoft
- Salesforce (SFDC)
Data Integration
Information Security
Systems Development Life Cycle (SDLC)
- Data Modeling
- Design
- Develop
- Test
- Sustainment
Career Management
Databases
- DashDB
- DB2
- Netezza
- ODBC
- Oracle
- MySQL
- Salesforce (SFDC)
Structured Query Language (SQL)
- Alter
- Cast
- Comment
- Create
- Date
- Stored Procedure
- Substring / Substr
- Table
- Timestamp
- Truncate
- View

Post navigation

← Previous Next →

Netezza/PureData – How to add days to a date field

Posted on October 16, 2015 by Bert Swope

Netezza/PureData – How to add days to a date field

IBM Netezza / IBM PureData for Analytics

Here are a few examples of how to add days to a date field in Netezza:

Add a day to a Date Field

date(current_date + cast(‘1 days’ as interval)) as DATE_PLUS_1

Adding 3 Days to Current Date

date(current_date + cast(‘3 days’ as interval)) as CURRENT_DATE_PLUS_3

Related References

IBM PureData System for Analytics -SQL functions
PureData – Now() Command For Current Date
Netezza – How GET to Database UTC Offset With SQL
Netezza/PureData SQL Date Formatting Example
Netezza / PureData – CURRENT_TIMESTAMP Function

Share this:

Twitter
Telegram
Skype
Print
Facebook
Google
LinkedIn
Pinterest
Tumblr
Reddit
Email
WhatsApp
Pocket

Like this:

Like Loading...

Related

This entry was posted in All categories, Computer Science, DataBase Management Systems (DBMS), Databases, Date, IBM, Information Science, Information Systems, Information Technology, Netezza, PureData, Relational Database Management Systems (RDBMS), Science and Information Area, Science Of Science, Structured Query Language (SQL) and tagged #databaseadministration, #DatabaseAdministrator, #datawarehouse, #InformationManagement, #Informationtechnology, #IT, #softwaredevelopment, #softwaretesting, #technology, 7.0.x, 7.1.0.x, 7.2.0.x, 7.2.1, 7.2.x, add 1 day to date, add 1 day to date in netezza, add 1 day to date sql, add 10 days to date sql, add 14 days to date in sql, add 15 days to date in sql, add 2 days to current date in sql, add 3 days to date sql, add 30 days to current date in sql, add 30 days to date, add 30 days to date in sql, add 30 days to date sql, add 365 days to a date, add 45 days to a date sql, add 5 days to date sql, add 60 days to a date in sql, add 60 days to a date sql, add 7 days to date, add 7 days to date sql, add 90 days to a date sql, add 90 days to date, add 90 days to date sql, add business days to date, add date by 1 in netezza, Add Days, add days date sql query, add days function, add days to a date field in sql, add days to a date in sql, add days to a date sql, add days to current date in sql, add days to current date sql, add days to date, add days to date field, add days to date field sql, add days to date in netezza, add days to date in sql, add days to date netezza, add days to date sql, add days to date sql query, add days to sql date, add no of days to date in sql, add number of days to date, add number of days to date sql, add one day to date sql, add one day to sql date, add two days to date sql, add working days to a date sql server, add working days to date sql, adding 1 day to date, adding days to a date, adding days to current date sql, adding days to date in netezza, adding days to date in sql, ADD_DAYS, Aginity, Analytics, big Data, BigData, BigSQL, DashDB, Data Warehouse, Database Administration, Database Administrator, Databases, Function, Groom, how to add days to a date in netezza, how to add days to date column in sql, how to add days to date field in sql, how to add days to date in netezza, how to add days to date sql, IBM, Information Managment, Information Technology, Netezza, netezza date add days, netezza sql add days to date, PureData, PureSystems, query add days to date, Relational Database Management Systems (RDBMS), relational database structured query language, Software Development, Software Testing, sql add 3 days to date, sql add 30 days to date, sql add 365 days to date, sql add days to date, sql add days to date column, sql add days to date field, sql add number of days to date, sql add x days to date, sql date add days to date, sql function add days to date, sql function to add days to date, sql query to add days to current date, sql update add days to date, Structured Query Language, Structured Query Language (SQL), structured query language basic commands, structured query language basics, structured query language commands, structured query language database, structured query language examples, structured query language features, structured query language for beginners, structured query language for dummies, structured query language functions, structured query language in database, structured query language in database management system, structured query language in dbms, structured query language manual, structured query language notes, structured query language programming, structured query language queries, structured query language sql queries, structured query language statements, structured query language tables, structured query language uses, Tech, Testing, understanding structured query language, use basic structured query language by Bert Swope. Bookmark the permalink.

6 thoughts on “Netezza/PureData – How to add days to a date field”

Pingback: Netezza/PureData SQL Date Formatting Examples | Scientia Compendium
Pingback: PureData – CURRENT_TIMESTAMP Function | Scientia Compendium
Pingback: Netezza – Useful links | Scientia Compendium
Pingback: PureData – Current Date Function | Scientia Compendium
Pingback: PureData – Now() Command For Current Date | Scientia Compendium
Pingback: Infosphere Datastage – Useful Date Transformations | Scientia Compendium

Comments are closed.

Social

View @ScientiaCmpndm’s profile on Twitter
View albertswope’s profile on LinkedIn

Blog at WordPress.com.

Post to

Cancel

Send to Email Address Your Name Your Email Address

Cancel

Post was not sent - check your email addresses!

Email check failed, please try again

Sorry, your blog cannot share posts by email.

%d bloggers like this: