Netezza - Current Date and Current timestamp

Netezza Syntax to get Current Date and Current Timestamp values

SELECT CURRENT_TIMESTAMP
SELECT CURRENT_DATE

5 comments:

  1. kdpJuly 5, 2013 at 9:38 AM

    Thanks for the efforts on gathering useful content and sharing here. You can find more question and answers on Netezza database in the following forum.

    Netezza database question and answers

    ReplyDelete
  2. 21st Century Software SolutionsMay 22, 2014 at 12:59 PM

    NETEZZA Online Training -
    http://www.21cssindia.com/courses/netezza-developer-online-training-21.html
    IBM Netezza Overview - Netezza Architecture - Connecting to Netezza - Databases - Tables - Database Objects - Data Distribution - Loading and Unloading Tables - Statistics - Zone Maps - Clustered Base Tables - Materialized Views - Groom - Sequences - Transactions - Query and System Optimization - Nz commands - Backup and Restore - Creating user and User management - Query History - Managing Workloads - Managing Events - contact@21cssindia.com ---- Call Us +919000444287

    ReplyDelete
  3. UnknownJuly 11, 2014 at 1:14 PM

    Hi ,
    ThankYou Sir provided Good information about IBM Netezza it is very usefull to IBM Netezza Learners you course content also good.Netezza is widely credited for either inventing or bringing renewed attention to the data warehouse appliance category. We also providing IBM Netezza Online Training by Certified Professionals

    ReplyDelete
  4. UnknownJune 2, 2017 at 4:09 PM

    I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in NETEZZA TRAINING, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Sangita Mohanty
    MaxMunus
    E-mail: sangita@maxmunus.com
    Skype id: training_maxmunus
    Ph:(0) 9738075708 / 080 - 41103383
    http://www.maxmunus.com/

    ReplyDelete
  5. UnknownDecember 5, 2018 at 9:43 PM

    Hello,

    I am new to Netezza. currently i am converting the sql scripts to Netezza script . Sql contains a variable and value set as getdate(). How do to declare a variable and set a value as getdate() in netezza , aginity workbench? kindly help me with it

    Thanks

    ReplyDelete

Subscribe to: Posts (Atom)