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: 45155 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......
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: 283 Database Star
SQL 36, trunc function
 
02:36
What you can do with trunc function in SQL
Views: 4050 hammadshams
Oracle TO_DATE Function Explained with Examples
 
06:14
https://www.databasestar.com/oracle-to_date/ The Oracle TO_DATE function is one of the most useful conversion functions in Oracle. It can be a little confusing though. The TO_DATE function is used to convert a character value to a date value. You can use it to convert a string that is in the format of a date, into a date data type. Why would you use this? Converting a character to a date is helpful if you want to insert a date into a column in a table. Being specific about the format (explicit) is better than assuming the conversion will be done for you (implicit). This TO_DATE function only converts to a DATE data type. If you want to convert to the other datetime data types, you’ll have to use other functions such as TO_TIMESTAMP or TO_TIMESTAMP_TZ. The syntax for this function is: TO_DATE(charvalue [, format_mask [, nls_date_language]]) The parameters for this function are: Charvalue: This is the character value that you want to convert to a date. It’s the main input of the function. Format_mask: This is the format that the input value, the charvalue, is in. This is used to help convert your character value into a date, as your character may be in a different format to the default. Nls_date_language: this is used to determine how the output is displayed. For more information about the Oracle TO_DATE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-to_date/
Views: 1447 Database Star
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: 5023 LiveLessons
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: 725 Aprenda PL/SQL
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: 88 Ganesh Anbarasu
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: 271 Database Star
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: 441 Database Star
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: 1191 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: 19552 ITORIAN
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: 35435 The Bad Tutorials
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: 19 Ganesh Anbarasu
Use of TRUNC Function for separating Date and Time in Excel sheet
 
01:59
excel function TRUNC various usages........
Views: 121 Er.Sathavara Dinesh
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: 59 Ganesh Anbarasu
SQL 38, Extract Function be42.flv
 
01:16
SQL extract example
Views: 857 hammadshams
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: 36102 The Bad Tutorials
Filtering on Date Values using the SQL WHERE Clause (Introduction to Oracle SQL)
 
03:36
How to filter on date values in SQL using the SQL WHERE clause. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 298 Database Star
2 13 SYSDATE vs CURRENT DATE
 
01:25
Oracle SQL SYSDATE vs CURRENT_DATE
Views: 448 Mahesh Peiris
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: 2310 Pebbles Tutorials
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: 40 DBA Genesis
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: 530 Aprenda PL/SQL
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: 94428 Manish Sharma
ORACLE: How to get FIRST and LAST DAY of  Month ?
 
00:56
SQL Language, available for any version of Oracle Database.
Views: 5411 1Click2beDBA
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: 941 Database Star
NULLIF FUNCTION IN ORACLE SQL WITH EXAMPLE
 
03:24
This video is the 3rd video in the series of 'working with null in oracle sql', the video demonstrates the use of NULLIF function in oracle sql, and how we can use it in day to day coding time. The video explains the function with perfect easy to understand example.
Views: 1397 Kishan Mashru
Oracle SQL Video Tutorial 20 - TO_CHAR Functions
 
17:02
Oracle SQL Video Tutorials 20 - TO_CHAR Functions explained
Views: 7359 Just Channel
ADD_MONTHS Function in SQL Query with Example
 
02:32
ADD_MONTHS(): The Oracle/PLSQL ADD_MONTHS function returns a date plus n months. Syntax: ADD_MONTHS( date1, n ) Arguments: date1 is the starting date (before the n months have been added). n is the number of months to add to date1. Example: Let's look at some Oracle ADD_MONTHS function examples and explore how you would use the ADD_MONTHS function in Oracle/PLSQL. ADD_MONTHS('01-Aug-03', 3) would return '01-Nov-03' ADD_MONTHS('01-Aug-03', -3) would return '01-May-03' ADD_MONTHS('21-Aug-03', -3) would return '21-May-03' ADD_MONTHS('31-Jan-03', 1) would return '28-Feb-03' Thanks for watching..:)
Views: 1119 WingsOfTechnology
Restore Oracle Deleted Rows
 
05:02
How to restore deleted rows in oracle insert into employee ((select * from employee as of timestamp systimestamp - interval '4' minute) minus (select * from employee))
Views: 53 Mohammad
ORACLE SQL 24: NEXT_DAY, LAST_DAY
 
05:16
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 760 studyandsharevn
Oracle SQL Video Tutorial 19 - DATE functions
 
06:54
Oracle SQL Video Tutorials 19 - DATE functions explained
Views: 4304 Just Channel
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: 2594 hammadshams
SQL Tutorial - 46: Date & Time Functions (Part-2)
 
05:36
In this tutorial we'll understand how we can view the day name for a particular date, view the current date and time through a single function and also to make dates with year and day values through the DAYNAME(), NOW() and MAKEDATE() functions respectively. Thanks for watching!
Views: 20482 The Bad Tutorials
Extract Oracle data
 
01:39
Extract Oracle data with customized tasks
Views: 207 TLIUpdates
SQL with Oracle 10g XE   Using the ROUND and FLOOR Functions
 
06:18
In this video I use the ROUND and FLOOR functions found in SQL. I use the ROUND function to round my figures to the nearest dollar and view the results to see how it rounds. I then round those same figures to the nearest tenth and hundredth. Using a negative number as my parameter will allow me to round to tens, hundreds, etc. The FLOOR function will just drop the decimal values without rounding.This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 4229 Lecture Snippets
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: 29 Ganesh Anbarasu
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
Função Oracle MONTHS BETWEEN
 
04:54
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função de MONTHS_BETWEEN retorna a diferença de meses entre duas datas. SELECT months_between(TO_DATE('28/12/2017', 'DD/MM/YY'), TO_DATE('03/08/2017', 'DD/MM/YY')) AS MONTHS_BETWEEN FROM dual; SELECT trunc(months_between(TO_DATE('28/12/2017', 'DD/MM/YY'), TO_DATE('03/08/2017', 'DD/MM/YY'))) AS MONTHS_BETWEEN FROM dual; SELECT round(months_between(TO_DATE('28/12/2017', 'DD/MM/YY'), TO_DATE('03/08/2017', 'DD/MM/YY'))) AS MONTHS_BETWEEN FROM dual; https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 652 Aprenda PL/SQL
SQL 38, Extract Function ce42
 
01:14
SQL extract function another example
Views: 855 hammadshams
Learn MySQL In Arabic #31 - Numeric Functions - Mod, Truncate, Pow
 
14:30
Learn Math properties and numeric functions with examples Mod Truncate Pow
Views: 4694 Elzero Web School
Função Oracle ADD MONTHS
 
05:29
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função ADD_MONTHS no Oracle recebe 2 parâmetros, sendo o primeiro a data que vai ser manipula e o segundo um inteiro que pode ser positivo ou negativo referente a quantidade de meses que serão adicionados ou subtraídos. SELECT trunc(sysdate) AS Data_atual, add_months(trunc(sysdate), 5) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('29/02/16', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('28/02/17', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('27/02/16', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT trunc(sysdate) AS Data_atual, add_months(trunc(sysdate), -1) AS ADD_MONTHS FROM dual; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 506 Aprenda PL/SQL
SQL 37 -How to calculate age Part 1
 
05:05
Structured Query Languge
Views: 6911 hammadshams
คำสั่ง 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: 395 Akira Shoyasu
Função Oracle NEXT DAY
 
03:15
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função NEXT_DAY recebe 2 parâmetros de entrada, onde o primeiro é uma data e o segundo é o dia da semana que eu quero trazer a próxima data. Esta função retorna o próximo dia da semana em comparação a primeira data. SELECT next_day(TO_DATE('01/07/2017', 'DD/MM/YY'), 'SUNDAY') AS prox_sabado, next_day(TO_DATE('29/06/2017', 'DD/MM/YY'), 'SAT') AS prox_quinta FROM dual; SUNDAY - SUN MONDAY - MON TUESDAY - TUE WEDNESDAY- WED THURSDAY - THU FRIDAY - FRI SATURDAY - SAT Veja os outros vídeos da nossa Playlist https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 450 Aprenda PL/SQL
Numeric Functions in SQL | Oracle SQL fundamentals
 
06:16
Enroll into full course with free cloud access for 30 days: https://dbagenesis.com/p/oracle-sql-fundamentals/
Views: 22 DBA Genesis
MYSQL: Numeric functions
 
09:04
Views: 10525 CS IP for You
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: 38 Votoinc Inc