-
query and date format
I have date column that contains date and time. I want to only get back
distinct dates in YYYYMMDD format.
I start with alter session set nls_date_format = 'YYYYMMDD'
When I run this query below
select distinct(create_date) from table_A partition (BLA)
I am getting back more than one row as shown below. What do I have to do to just one row per YYYYMMDD
CREATE_D
--------
20101021
20101021
20101021
20101021
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|