UDATE supports two-digit year i.e in the form MMDDYYYY and system date supports four digit year i.e in the form MMDDYY.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The date got from SYSDATE is date according to client machine....
- let sysdate='19-SEP-2009' select round(sysdate,'YEAR'),round(sysdate,'MONTH') from dual would results in?
- What is the system field for the current date?
- What is the system field for the current date?
- which of the following is the valid format?
- If we are limited to 5 bytes of storage, is there be a way to store a complete 8 digit date?
- DATA: ULTIMO TYPE D. ULTIMO = SY-DATUM. ULTIMO+6(2) = '01'. ULTIMO = ULTIMO - 1. write: ultimo.
- If sysdate is ‘17/10/2009’and we run the following query,what will be the Output?