Good pickup! I'm guessing it's to do with the timezone. I'm based in Australia which is UTC + 11, so perhaps I recorded and uploaded it in the morning but TH-cam may be based on US time or UTC which could be the day before.
It's because the number 9 is used by Oracle to represent any kind of number. It doesn't actually show the number 9, it's just used as an indication. Hope that makes sense.
The .7 is kept because the format mask you supplied (which is the 99999.9) specifies that you want to show one decimal place. The number displayed is .7 because the original number of .6789 is rounded to one decimal place, so .67 is rounded to .7.
hi sir, 1)select to_char('12/06/2022','dd/mm/yy') from dual; 2)select to_char(sysdate,'dd/mm/yy') from dual; why 2nd one is working while first one is not working?
I think it’s because the first parameter needs to be a date in a specific format if you enter it inside quotes. And I think the default format is DD-MON-RR so your input should be 12-JUN-22.
Thank you.
You're welcome!
At 3:12 -> June 16, 2018 but the video was June 15, 2018. Why ?
Good pickup! I'm guessing it's to do with the timezone. I'm based in Australia which is UTC + 11, so perhaps I recorded and uploaded it in the morning but TH-cam may be based on US time or UTC which could be the day before.
Why for example only the number 9 works? I tried using other numbers such as 88888.8 and it didn't work. Please explain.
It's because the number 9 is used by Oracle to represent any kind of number. It doesn't actually show the number 9, it's just used as an indication. Hope that makes sense.
SAME lol
Can you please make a video on how to take an input from the user in the runtime using Oracle Live?
Sure I can do that!
If I run SELECT TO_CHAR(12345.6789, '99999.9') I get the same result of 12345.7
What is the logic of keeping the .7?
The .7 is kept because the format mask you supplied (which is the 99999.9) specifies that you want to show one decimal place. The number displayed is .7 because the original number of .6789 is rounded to one decimal place, so .67 is rounded to .7.
thanks bud. helping me cram for m cosc304
No problem, happy to help!
hi sir,
1)select to_char('12/06/2022','dd/mm/yy') from dual;
2)select to_char(sysdate,'dd/mm/yy') from dual;
why 2nd one is working while first one is not working?
I think it’s because the first parameter needs to be a date in a specific format if you enter it inside quotes. And I think the default format is DD-MON-RR so your input should be 12-JUN-22.