Home
Search results “Oracle date trunc day”
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 48281 etldeveloper
Oracle || Date functions Part-1 by dinesh
 
17:06
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Working with dates in Oracle PLSQL.
 
23:34
Dates in Oracle PL SQL is definitely the most powerful among all other databases. It gives us full flexibility to manipulate it of our choice, whether you are calculating days, months or year, printing date and time in various format. Useful date functions add_months, months_between, last_day, next_day and to_char helps us a lot in handling date time in our pl sql programming.
Views: 5961 Subhroneel Ganguly
SQL 36, trunc function
 
02:36
What you can do with trunc function in SQL
Views: 4295 hammadshams
Oracle Tutorial - Date Functions NEXT_DAY | LAST_DAY
 
07:13
Oracle Tutorials - Date Functions NEXT_DAY( ) | LAST_DAY( )
Views: 231 Tech Acad
018-Oracle SQL 12c: Date functions
 
27:19
تعلم اوراكل حتى الاحتراف تعلم اوراكل من الصفر
Views: 5298 khaled alkhudari
Oracle SQL TUTORIAL – Date columns with Time in Where condition
 
12:41
In this video, we will see how to retrieve records for a specific time duration. SQLs used in this video are given below. select * from employees; alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS'; SELECT DBMS_RANDOM.VALUE(0,9) FROM DUAL; SELECT SYSDATE-DBMS_RANDOM.VALUE(0,9) FROM DUAL; SELECT FIRST_NAME,LAST_NAME, SYSDATE-DBMS_RANDOM.VALUE(0,9) CREATED_DATE FROM EMPLOYEES; CREATE TABLE EMP_TEST AS SELECT FIRST_NAME,LAST_NAME, SYSDATE-DBMS_RANDOM.VALUE(0,9) CREATED_DATE FROM EMPLOYEES; SELECT * FROM EMP_TEST ORDER BY CREATED_DATE DESC; select sysdate from dual; select sysdate,trunc(sysdate) from dual; 26 sep 2018 00:00:00 to 26 sep 2018 23:59:59 select sysdate,trunc(sysdate),trunc(sysdate)+0.99999 from dual; Records that got created yesterday.. 25 sep 2018 00:00:00 to 25 sep 2018 23:59:59 select trunc(sysdate-1),trunc(sysdate-1)+0.99999 from dual; SELECT * FROM emp_test WHERE created_date BETWEEN trunc(SYSDATE-1) AND trunc(SYSDATE-1)+0.99999 order by created_date; Retrieve records for 22nd Septembter 2018 SELECT * FROM emp_test WHERE created_date BETWEEN to_date('22-sep-2018 00:00:00','dd-mon-yyyy hh24:mi:ss') AND to_date('22-sep-2018 23:59:59','dd-mon-yyyy hh24:mi:ss') order by created_date; SELECT * FROM emp_test WHERE created_date BETWEEN to_date('22-sep-2018','dd-mon-yyyy') AND to_date('22-sep-2018 23:59:59','dd-mon-yyyy hh24:mi:ss') order by created_date; -- Get all records created in last 24 hours select sysdate,sysdate-1 from dual; SELECT * FROM emp_test where created_date between sysdate-1 and sysdate order by created_date;
Views: 221 Ganesh Anbarasu
Oracle Tutorial Date Function - 2
 
07:10
Oracle Date Function, Order by Month Year. Getting employee count hired month, yearwise and order by hiring month and year. SQL Used in the video below. select * from employees order by hire_date; select hire_date,to_char(hire_date,'Month,YYYY') from employees; select to_char(hire_date,'Month,YYYY')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_char(hire_date,'Month,YYYY') select to_char(hire_date,'Month,YYYY')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_date(to_char(hire_date,'Month,YYYY'),'Month,YYYY') select replace(to_char(hire_date,'Month,YYYY'),' ','')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_date(to_char(hire_date,'Month,YYYY'),'Month,YYYY')
Views: 112 Ganesh Anbarasu
Oracle SQL Video Tutorial 19 - DATE functions
 
06:54
Oracle SQL Video Tutorials 19 - DATE functions explained
Views: 4338 Just Channel
ORACLE: How to extract MONTH from DATE ?
 
00:50
Available for any version of Oracle Database.
Views: 49 1Click2beDBA
How to use tricky things with SYSDATE
 
04:59
How to use tricky things with SYSDATE like how to know the next day, next hour, next minuite etc.,
Views: 1300 Techie Rajesh
38. Date Functions - Add_Months, Last_Day, Months_Between, Next_Day, To_Date, New_Time in Oracle
 
07:53
In this video you will learn about Date Functions { Add_Months(), Last_Day(), Months_Between(), Next_Day(), To_Date(), New_Time() } in Oracle. Unlike other programming language Oracle also uses functions to perform common operations. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 20575 ITORIAN
Oracle CURRENT_TIMESTAMP Function
 
02:37
https://www.databasestar.com/oracle-date-functions/ The Oracle CURRENT_TIMESTAMP function will display the current date and time in the session time zone. Just like the CURRENT_DATE function, it uses the session time zone, which is where you logged in from. This could be different to the database time zone. The syntax of the CURRENT_TIMESTAMP function is: CURRENT_TIMESTAMP ( [precision] ) The return type of this function is TIMESTAMP WITH TIME ZONE. The precision parameter is optional, and it lets you specify the number of fractional seconds to return. If this is omitted, it uses the default of 6. It’s different to the SYSTIMESTAMP function, because CURRENT_TIMESTAMP returns the session timezone, and SYSTIMESTAMP returns the database time zone. So, if I’m logging in from Melbourne, Australia, and the database is in London, England, then the CURRENT_TIMESTAMP will return a date and time that’s 10 hours ahead of SYSTIMESTAMP, and in a different time zone. It may be on the same day, or it could be a different day, depending on when I run the function. You can perform arithmetic on this function just like any other date value (e.g. CURRENT_TIMESTAMP - 7 for 7 days ago). However, it might be better to use interval data types so you can keep the original data type. For more information about the Oracle CURRENT_TIMESTAMP function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-date-functions/
Views: 406 Database Star
Oracle Tutorial Date Function - An Introduction
 
16:43
In this video, we have covered Oracle SQL Date functions: SYSDATE , CURRENT_DATE , MONTHS_BETWEEN , ADD_MONTHS , TRUNC. This video covers topics required for Oracle 1Z0-071 certification exam.
Views: 28 Ganesh Anbarasu
Função Oracle TRUNC
 
04:47
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função TRUNC faz o arredondamento para baixo de todos os valores e ela pode receber como parâmetro principal de entrada tanto um campo do tipo NUMBER como um DATE! SELECT first_name, salary / 2.7, round(salary / 2.7) AS ROUND, trunc(salary / 2.7) AS TRUNC FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, salary / 2.7, round(salary / 2.7, 2) AS ROUND, trunc(salary / 2.7, 2) AS TRUNC FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'MONTH') AS ROUND, trunc(hire_date, 'MONTH') AS TRUNC FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'DAY') AS ROUND, trunc(hire_date, 'DAY') AS TRUNC FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'YYYY') AS ROUND, trunc(hire_date, 'YYYY') AS TRUNC FROM hr.employees WHERE job_id ='IT_PROG'; Vídeo Função ROUND https://youtu.be/TIwy9AthJf8 Veja os outros vídeos da nossa Playlist https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 799 Aprenda PL/SQL
Oracle TO_NUMBER Function
 
02:42
https://www.databasestar.com/oracle-to_number/ The Oracle TO_NUMBER function is used to convert a text value into a number value. It’s similar to TO_CHAR and TO_DATE, but converts a value to a number. The number will also be rounded to a specified number of digits, and returned as a NUMBER value. The syntax is: TO_NUMBER( input_value, [format_mask], [nls_parameter] ) The input_value is the value to be converted to a number. Commonly this is provided as a string (e.g. CHAR or VARCAHR2) but can be several other data types as well. The format_mask is the format that the output value should be displayed as. It must be a valid number format. This is an optional value. The final parameter, nls_date_language, is used to work out how the output is displayed, such as how to display currency symbols. It’s also an optional value. For more information about the Oracle TO_NUMBER function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-to_number/
Views: 2602 Database Star
ORACLE: How to get FIRST and LAST DAY of  Month ?
 
00:56
SQL Language, available for any version of Oracle Database.
Views: 5509 1Click2beDBA
Oracle SQL: Exploring Date Functions
 
07:29
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Exploring Date Functions is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 5369 LiveLessons
Learn Oracle | How to use the Character Functions, Date Functions in SQL
 
14:53
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 2645 Pebbles Tutorials
SQL Tutorial - 34: ROUND() Function
 
06:51
In this tutorial we'll see how we can round off numbers conveniently in SQL using the ROUND() Function/
Views: 37848 The Bad Tutorials
EXCEL: Difference between INT and TRUNC functions
 
08:47
EXCEL: Difference between INT and TRUNC functions INT function The formula syntax and usage of the INT function in Microsoft Excel. Description Rounds a number down to the nearest integer. Syntax INT(number) The INT function syntax has the following arguments: Number Required. The real number you want to round down to an integer. TRUNC function Description Truncates a number to an integer by removing the fractional part of the number. Syntax TRUNC(number, [num_digits]) The TRUNC function syntax has the following arguments: Number Required. The number you want to truncate. Num_digits Optional. A number specifying the precision of the truncation. The default value for num_digits is 0 (zero). Remark TRUNC and INT are similar in that both return integers. TRUNC removes the fractional part of the number. INT rounds numbers down to the nearest integer based on the value of the fractional part of the number. INT and TRUNC are different only when using negative numbers: TRUNC(-4.3) returns -4, but INT(-4.3) returns -5 because -5 is the lower number.
Views: 335 Allan Sam
Oracle MONTHS_BETWEEN Function
 
02:17
https://www.databasestar.com/oracle-months_between/ The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference. This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions. The syntax of the MONTHS_BETWEEN function is: MONTHS_BETWEEN(date1, date2) What do these two parameters mean? The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative. What data type is returned? It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value. For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here: https://www.databasestar.com/oracle-months_between/
Views: 1142 Database Star
Date Functions (Introduction to Oracle SQL)
 
05:48
Learn what date functions are and see some examples of them. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 426 Database Star
คำสั่ง TRUNC ตัดค่าวันที่กับตัวเลขแบบง่าย ๆ ใน Oracle
 
08:10
คำสั่ง TRUNC ตัดค่าวันที่กับตัวเลขแบบง่าย ๆ ใน Oracle ดูเพิ่มเติมได้ที่ http://www.doesystem.info/2016/07/oracle-trunc.html โปรแกรม สอนใช้โปรแกรม สอน แนะนำ และช่วยแก้ปัญหา เกี่ยวกับคอมพิวเตอร์และไอที สอนการใช้งาน การเรียนรู้ การแก้ปัญหา การทำเว็บไซต์ การเขียนโปรแกรม และไอทีอื่น ๆ Oracle คำสั่ง TRUNC เบื้องต้น บทความนี้เรามาดูคำสั่งใน Oracle กันอีกซักหน่อย ซึ่งคำสั่งนั้นคือ TRUNC ครับ ในคำสั่ง TRUNC นั้นสามารถใช้ได้ทั้งตัวเลขและก็เวลาเลยครับ นั่นก็แปลว่ามันจะมีทั้งคำสั่ง TRUNC(date) และก็ TRUNC(number) มาดู Syntax กันก่อนดีกว่าครับ TRUNC(number) Syntax ของ TRUNC(number) แสดงได้ดังด้านล่าง TRUNC(n1 [, n2 ]) TRUNC(number) เมื่อเรียกใช้จะรีเทิร์นค่าเป็นตัวเลขที่ถูกตัดออก ตัวตำแหน่งของตัวที่ถูกตัดออกจะถูกกำหนดด้วย n2 แต่ถ้าไม่ได้กำหนด n2 มาให้ n2 จะถูกแทนที่ด้วยเลข 0 ในฟังก์ชัน TRUNC(number) นี้เราสามารถกำหนดได้ทั้งจำนวนลบ บวก หรือ 0 ก็ได้ทั้งนั้น เรามาดูตัวอย่างการใช้งานกัน ตัวอย่างคำสั่ง TRUNC(number) แบบง่าย ๆ select trunc(19.32, 0) from dual; ผลลัพธ์ที่ได้ก็คือ 19 เพราะตัดตำแหน่งที่ 0 select trunc(19.32, 1) from dual; ผลลัพธ์ที่ได้คือ 19.3 เพราะตัดตำแหน่งที่ 1 select trunc(19.32, -1) from dual; ผลลัพธ์ที่ได้คือ 10 เพราะตัดตำแหน่งที่ -1 นั่นคือย้อนกลับไปหนึ่งตำแหน่งก็คือ 10 เลข 9 ตัดทิ้ง TRUNC(date) Syntax ของ TRUNC(date) แสดงได้ดังด้านล่าง TRUNC(date [, fmt ]) TRUNC(date) เมื่อเรียกใช้ฟังก์ชันนี้แล้วจะรีเทิร์นค่าเป็น Date ซึ่ง Date ที่ได้จะเป็นเวลาที่ถูกตัดโดยกำหนดไว้ใน fmt ข้อมูลที่ได้จะเป็นข้อมูล Date เสมอแม้ว่าจะกำหนดตัวแปรเป็น DateTime ก็ตามแต่ สำหรับ fmt ที่ใส่ได้นั้นแสดงได้ตามด้านล่าง Unit Valid format parameters Year SYYYY, YYYY, YEAR, SYEAR, YYY, YY, Y ISO Year IYYY, IY, I Quarter Q Month MONTH, MON, MM, RM Week WW IW IW W W Day DDD, DD, J Start day of the week DAY, DY, D Hour HH, HH12, HH24 Minute MI เมื่อได้ format แล้วเรามาลองเรียกใช้งานกันดูครับ ตัวอย่างง่าย ๆ สำหรับการใช้งานฟังก์ชัน TRUNC ใน Oracle แสดงได้ดังนี้ select trunc(to_date('04-07-2016', 'DD-MM-YYYY'), 'YEAR') from dual; เมื่อรันคำสั่งนี้จะได้ผลลัพธ์เป็น 01-JAN-16 ซึ่งเราใช้ฟอร์แมท YEAR เป็นฟอร์แมทของปีดังนั้นมันจะตัดทิ้งแล้วไปต้นปีนั่นก็คือวันที่ 1 มกราของปีนั้น ๆ คือ 1 JAN 2016 select trunc(to_date('04-07-2016', 'DD-MM-YYYY'), 'MONTH') from dual; ตัวอย่างนี้เมื่อรันแล้วจะได้ผลลัพธ์เป็น 01-JUL-16 ซึ่งก็ได้ว่าฟอร์แมทที่เราใช้นั้นเป็น MONTH ซึ่งเป็นเดือน ดังนั้นมันจะกระโดดไปต้นเดือนแล้วตัดส่วนอื่นทิ้งนั่นก็คือต้นเดือนวันที่ 1 JUL 2016 สำหรับฟอร์แมทอื่น ๆ หรือตัวเลขอื่น ๆ ของไปเล่นกันดูครับ
Views: 442 Akira Shoyasu
Oracle TO_TIMESTAMP Function
 
01:31
https://www.databasestar.com/oracle-to_timestamp/ The Oracle TO_TIMESTAMP function can be confusing, but we’ll explain it in this video. This function allows you to convert a string value into a TIMESTAMP value. A TIMESTAMP value is a type of DATE, but has a few components: - A date, including day, month, and year - A time, including hours, minutes, seconds, and fractional seconds This is a useful data type because it allows you to store a time down to fractions of a second. The syntax of the TO_TIMESTAMP function is: TO_TIMESTAMP ( input_string [, format_mask] [, nls_param] ) The input_string parameter is the string you want to convert. The format_mask is where you specify the format of the input_string parameter. This is so you can specify the input_string in a variety of formats, and just use this format_mask to indicate which format it is in. The nls_param parameter is another optional parameter, and allows you to specify the returning language of the month and day names. The default format will depend on the region you’re running your database in. In my example (using Oracle Express in Australia), the default format is ‘DD-MM-RRRR HH:MI:SS AM’. For more information on the Oracle TO_TIMESTAMP function, including the SQL used in this video, read the related article here: https://www.databasestar.com/oracle-to_timestamp/
Views: 512 Database Star
Date Functions in SQL | Oracle SQL fundamentals
 
10:57
Enroll into full course with free cloud access for 30 days: https://dbagenesis.com/p/oracle-sql-fundamentals/
Views: 96 DBA Genesis
ORACLE SQL Tutorial to get Years of Experience
 
17:26
In this video, we will see how add_months, months_between can be used to get Years of work experience for an employee. SQL used in this video are given below. select add_months(sysdate,2) from dual; select months_between(sysdate,to_date('22082016','ddmmyyyy') ) from dual; select trunc(months_between(sysdate,to_date('22082016','ddmmyyyy') )) from dual; select mod(16,12) from dual; select * from employees; SELECT first_name,hire_date, trunc(months_between(SYSDATE,hire_date)) mnths_between from employees; 12 months = 1 year SELECT first_name,hire_date, trunc(months_between(SYSDATE,hire_date)) mnths_between, trunc(months_between(SYSDATE,hire_date)/12) years, trunc(months_between(SYSDATE,hire_date)) - trunc(months_between(SYSDATE,hire_date)/12)*12 No_of_Months from employees; SELECT hire_date,add_months(hire_date,trunc(months_between(SYSDATE,hire_date))) new_date from employees; SELECT hire_date, trunc(sysdate) - add_months(hire_date,trunc(months_between(SYSDATE,hire_date))) no_of_days from employees; SELECT first_name,hire_date, trunc(months_between(SYSDATE,hire_date)) mnths_between, trunc(months_between(SYSDATE,hire_date)/12) years, trunc(months_between(SYSDATE,hire_date)) - trunc(months_between(SYSDATE,hire_date)/12)*12 No_of_Months, trunc(sysdate) - add_months(hire_date,trunc(months_between(SYSDATE,hire_date))) no_of_days from employees;
Views: 89 Ganesh Anbarasu
Use of TRUNC Function for separating Date and Time in Excel sheet
 
01:59
excel function TRUNC various usages........
Views: 149 Er.Sathavara Dinesh
Learn SQL: Query 4: Working with DATES
 
02:01
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=adQR-EY6v2s&index=4&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=Mztp1M5FUN4&index=2&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) keywords SELECT FROM WHERE topic DATES
Views: 3380 Mark Keith
Função Oracle LAST DAY
 
03:51
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função LAST_DAY retorna o último dia do mês da data passada como parâmetro. SELECT trunc(sysdate) AS Data_atual, last_day(trunc(sysdate)) AS ultimo_dia_mes FROM dual; SELECT last_day(to_date('10/02/2016', 'DD/MM/YY')) AS ultimo_dia_mes FROM dual; SELECT hire_date, last_day(hire_date) AS Ultimo_dia_mes FROM hr.employees WHERE employee_id =114; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 578 Aprenda PL/SQL
SQL Tutorial - 45: Date & Time Functions (Part-1)
 
05:15
In this tutorial we'll see how we can add dates, subtract dates, view current date and current time using ADDDATE(), SUBDATE(), CURDATE() and CURTIME Functions respectively.
Views: 37057 The Bad Tutorials
Oracle ADD_MONTHS Function
 
03:15
https://www.databasestar.com/oracle-add_months/ The Oracle ADD_MONTHS allows you to add a specified number of months to a date value, and return the new date value. It’s great for performing calculations on dates, or date arithmetic, which can be hard in many different programming languages. The syntax of the ADD_MONTHS function is: ADD_MONTHS ( input_date, number_months ) The function returns a DATE value. The parameters of this function are: - input_date (mandatory): This is the starting date, or the date that you will add a number of months to. - number_months (mandatory): This is an integer value that represents the number of months to add to input_date. The input_date can be any datetime value, or even a character value that can be converted to a date. Also, the number_months can be any number value, or a character value that can be converted to a number. What if the number of days in the two months are different? For example, adding a month to Jan 31 could result in Feb 31, which does not exist. Well, in this case, Oracle would work out that the date does not exist, and use the last date of the month (e.g. Feb 28). You can also provide a negative value for ADD_MONTHS to subtract months from the specified date. For more information about the Oracle ADD_MONTHS function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-add_months/
Views: 532 Database Star
SYSDATE Function: SQL Tutorial 35
 
00:26
Please watch: "Install Oracle Database 12c Release 2 on Windows 10 Professional 64 bit" https://www.youtube.com/watch?v=5705VFJmku0 -~-~~-~~~-~~-~-
Views: 383 Solution Wizard
SQL 37 -How to calculate age Part 1
 
05:05
Structured Query Languge
Views: 7574 hammadshams
Oracle Database11g tutorials 10 ||  SQL Single Row Function (SQL Functions )
 
01:29
Single row functions Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers ============================================ in this oracle database tutorial we will see what are SQL FUNCTIONS. SQL functions are divided into two categories 1st is Single Row Functions And another one is Multiple row function which is also known as aggregate functions. But in today's SQL tutorial we will concentrate on Single Row Functions. Single-row functions operate on one row at a time and return one row of output for each input row. Single row functions are capable of manipulating data items and modifying the data types. Single row functions return one result per row and act on each row that is returned. Single row functions can accept one or more arguments and return one value. These arguments can be a column or an expression. With oracle we have 5 types of Single Row Functions 1. Character Functions 2. Number Functions 3. General Functions 4. Conversion Functions and 5. Date Functions. Character Functions are further divided into two categories. 1st is Case- manipulation functions and 2nd is Character Manipulation functions. We have 3 case manipulation functions Lower, upper and initcap and 7 character manipulation functions Sql functions concat, substr, length, instr, lpad, rpad, trim and replace. In our future video we will see what these functions are and what they do along with other SQL function. That's it for today's sql tutorial. Hope you enjoyed watching. Please don't forget to subscribe and like. Have a good day. This is Manish.
Views: 97221 Manish Sharma
2 13 SYSDATE vs CURRENT DATE
 
01:25
Oracle SQL SYSDATE vs CURRENT_DATE
Views: 639 Mahesh Peiris
Урок 33. SQL. Работа с датами.
 
10:41
В языке SQL Oracle диалекта существует множество функций для работы c типом date Напоминаю тип date содержит дату и время, например, время заполнения накладной , дату время создания записи в таблице Функция SYSDATE- текущая дата время если мы SYSDATE-1 предыдущий день, то же самое время SYSDATE-1/24*3 текущее время - 3 часа назад то есть единица обозначет сутки , а 1/24 один час учебная среда https://apex.oracle.com/pls/apex/ схема: SQLADV польз: student1 пароль: student1 будут работать (student2/ student2, student3/ student3 .... student11/ student11) меню SQL Workshop , SQL Command или используйте http://sqlfiddle.com/ скрипт бд для загрузки в sqlfiddle http://sqladv.ru/dev/sql.txt урок и задания http://sqladv.ru/dev/sqlbasic/l33.txt
Lesson 36 Day Month Year IsDate Datepart and Datename Function in SQL in Hindi
 
07:49
In this video we will learn Day, Month, Year, IsDate, DatePart and DateName Function in SQL in Hindi
Views: 366 Vijay Mulsaniya
Oracle DV - Use TimestampDiff to Calculate Interval Between Two Dates
 
01:46
This video shows simple way to leveage TimestampDiff function in Oracle DV to calculate time interval between two dates. Download the latest version of DV today https://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html.
Views: 403 Oracle Analytics
Oracle MOD: Number function
 
01:09
Oracle ROUND: Number Function https://www.youtube.com/watch?v=eWm_jON6NUI Oracle TRUNC: Number function https://www.youtube.com/watch?time_continue=3&v=4lchx4sseEM The usage of SELECT Playlist: https://www.youtube.com/watch?v=ZwgiIiD1dWE&list=PLjBraywgeSpEW2f7AK4Ddt6BRxW0HWN74
Oracle - SQL - Group Functions
 
03:13
Oracle - SQL - Group Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
sql single row functions date function
 
54:45
Single row function definition , character function -upper,lower,initcap,instr,substr,length,concat,lpad,rpad,trim,Replace Numeric functions- round,trunc,mod Date funtions-arithmatic operators with date,add_months,months_between,next_day,last_day General functions-nvl,nvl2,nullif,Coalsce,case expression,decode Conversion function-to_char,to_date with different formats .
Views: 44 Votoinc Inc
SQL 37 b age calculation, Part 2
 
04:59
Age calculation, second part of the video. I had the divide this video into two parts. Both are available from youtube and www.my-uni.net
Views: 2680 hammadshams
Training Oracle 12c Bab 4: Using Single-Row Functions to Customize Output
 
12:27
SQL Workshop Training di http://www.optimacomputer.com
31. SQL  Functions - Date
 
06:02
In this video we will learn about different date time functions in sql. Video from our Oracle SQL course. String Functions : https://youtu.be/NFjNIxvTBzc
Views: 147 ProSchool
How to use LPAD,RPAD function in Oracle Sql
 
04:48
How to use LPAD,RPAD function in Oracle Sql
Oracle SQL Data Conversion-Implicit Explicit
 
19:23
Oracle SQL Data Conversion Implicit Explicit Online console used -- https://livesql.oracle.com Implicit and Explicit data conversion to_char, to_number, to_date and cast functions Queries: /*IMPLICIT DATA CONVERSION EXAMPLES*/ SELECT salary + '10' FROM hr.employees; SELECT last_name FROM hr.employees WHERE employee_id = '200'; SELECT last_name FROM hr.employees WHERE employee_id = 200; SELECT last_name FROM hr.employees WHERE hire_date = '03-MAR-97'; Create table birth(name varchar2(15), dob date); Insert into birth values ('nids', '12/jan/58'); Insert into birth values ('panda', '14/feb/48'); Insert into birth values ('Spider', '14/feb/1958'); Insert into birth values ('agnes', '14/feb/2048'); Select * from birth; SELECT to_date('12-jan-58') - to_date('14-feb-48') from DUAL; '01/01/2058','MM/DD/RRRR' 01/01/2058 '01/01/2048','MM/DD/RRRR' 01/01/2048 '01/01/48','MM/DD/RRRR' 01/01/2048 '01/01/58','MM/DD/RRRR' 1/01/1958 '01/01/48','MM/DD/YYYY' 01/01/0048 '01/01/58','MM/DD/YYYY' 01/01/0058 '01/01/58','MM/DD/YY' 01/01/2058 '01/01/48','MM/DD/YY' 01/01/2048 SELECT * FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_DATE_FORMAT'; Alter session set nls_date_format = 'DD-MM-RRRR'; Select * from birth; alter session set nls_date_format = 'DD-MON-YYYY'; Select * from birth; ALTER session set nls_date_format = 'DD-MON-YY'; SELECT to_date('12-jan-58') - to_date('14-feb-48') from DUAL; ALTER session set nls_date_format = 'DD-MON-RR'; /*EXPLICIT DATA CONVERSION EXAMPLES*/ /*TO_CHAR, TO_DATE, TO_NUMBER*/ SELECT first_name, TO_CHAR (hire_date, 'MON DD, YYYY') HIRE_DATE, TO_CHAR (salary, '$99999.99') Salary FROM hr.employees; SELECT TO_CHAR('01110') FROM DUAL; SELECT TO_CHAR('01110' + 1) FROM DUAL; SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE( '5 Jan 2017', 'DD MON YYYY' ) FROM dual; SELECT TO_NUMBER('1210.73', '9999.99') from DUAL; SELECT TO_NUMBER('$65.169', 'L99.999') FROM DUAL; SELECT TO_NUMBER('123,456,789', '999,999,999') FROM DUAL; /*This example takes a complicated string, determines that it is in certain format, and specifies the numeric characters to use*/ SELECT TO_NUMBER('$17 218,00', 'L999G999D00',' NLS_NUMERIC_CHARACTERS='', ''') FROM DUAL; /*CAST*/ SELECT CAST( '22-Aug-2003' AS varchar2(30) ) from dual; SELECT CAST('245.205' AS NUMBER(5,2)) FROM dual; /*      -- Result: 245.21 (note that the value is rounded, not truncated to 245.20) */ SELECT CAST(245.205 AS NUMBER(5,2)) FROM dual; SELECT CAST ('123456' AS NUMBER) + 5 FROM DUAL; SELECT CAST ('5.05.2017' AS DATE) +5 FROM DUAL; /*check the default date format. That's why it give error*/ SELECT CAST ('30-APRIL-2015' AS DATE) +5 FROM DUAL; SELECT CAST (SYSDATE AS TIMESTAMP) FROM DUAL; SELECT SYSDATE FROM DUAL;
Views: 192 Nids Dixit