|
-
Re: difference between max(datecolumn) and max(to_date(datecolumn),'dd-mm-rrrr')
Originally posted by PSoni
select max(to_date(datecolumn),'dd-mm-rrrr) from atable ;
This has two syntax errors - so I don't think this is what gave the output posted.
Originally posted by PSoni
please note that type datecolum is date
Are you 100% sure? The results suggest that it is a character column - 31 is the highest value for the first two characters.
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
|
Reply With Quote