Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    6

    Netezza analog of MySQL date functions

    Can someone help me with the code below? What I need is the number of the day of the week from the report_dt field so I can use it to do some aggregations later. Basically, if its a monday, give me 1. the data in the report_dt field is in a date format (1/1/2012) etc.

    I know how to do this via MySQL but the closest thing I can figure out in Netezza is:
    SELECT date_part('day',report_dt) as report_dt
    FROM table

    which gives me the day of the month.

    thanks for any help

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    1. where is your netezza user manual?
    2. why post in the mysql forum?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •