|
-
Re: Re: difference between max(datecolumn) and max(to_date(datecolumn),'dd-mm-rrrr')
This has two syntax errors - so I don't think this is what gave the output posted.
PLEASE READ IT AS
select max(to_date(datecolumn,'dd-mm-rrrr)) from atable ;
Are you 100% sure? The results suggest that it is a character column - 31 is the highest value for the first two characters.
YES ITS DATE COLUMN
P.SONI
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
|