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: 42357 etldeveloper
SQL 36, trunc function
 
02:36
What you can do with trunc function in SQL
Views: 3780 hammadshams
ORACLE: How to get FIRST and LAST day of a month ?
 
00:56
ORACLE DATE FUNCTION - trunc(date) - last_day()
Views: 423 1Click2beDBA
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: 5190 Subhroneel Ganguly
trunc(sysdate-1)
 
03:49
Views: 135 matthew naquin
SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online
 
08:41
http://www.sqltrainingonline.com SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online In this video, I show you how to do a SQL Date Comparison in SQL Server when your Datetime has an actual time in it. I also include the latest trick that will make this easier if you are using SQL Server 2008 or SQL Server 2012. How do you compare a Datetime in SQL Server? A SQL Datetime stores both Date and Time. So when you are filtering using the SQL Where clause, you have to know if you Datetime is storing the time also. Let's take a look at the employee table in SQL Training Online Simple DB The column we are looking at is the hire date. I want to go after the person who was hired on February, 22 2005. So, I use the following SQL. select * from employee where hire_date='02/22/2005' Now, this works because we don't have any times stored in this column. But, if I change the record from 2005-02-22 00:00:00.000 to 2005-02-22 08:22:25.000 and rerun the query, you see that I don't get any results. That is because the value of 02/22/2005 is really 2005-02-22 00:00:00.000 and I just changed the hire_date to include a time other than 00:00:00.000. So, I have to tweak my query to use a greater than and less than sign. This works. But, to really understand what is going on, let me show you what SQL Server really sees. There are other ways, and in this StackOverflow article you can read more about these other ways. But, I want to point out a few. If you are working in SQL Server 2005 or earlier, the following is supposed to be the fastest performing way to do this. select datediff(dd,0, hire_date),* from employee where dateadd(dd,0, datediff(dd,0, hire_date)) = '2005-02-22' But, if you are working in SQL Server 2008 or SQL Server 2012, they have introduced an actual Date datatype that doesn't include the Time portion. Since this is the case, you can use the CAST function to remove the time from the Datetime. Here is the SQL to do that. select * from employee where CAST(hire_date AS Date) = '2005-02-22' And that's it. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 26498 Joey Blue
Use of TRUNC Function for separating Date and Time in Excel sheet
 
01:59
excel function TRUNC various usages........
Views: 105 Er.Sathavara Dinesh
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: 789 Database Star
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: 20 Ganesh Anbarasu
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: 359 Database Star
Extract Oracle data
 
01:39
Extract Oracle data with customized tasks
Views: 199 TLIUpdates
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: 1072 Techie Rajesh
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: 302 Database Star
Oracle Date Function SQL | PL SQL | ORACLE
 
04:20
Oracle Date Function
Views: 347 Online Pl Sql
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: 299 Solution Wizard
mod, power  sqrt & trunc | sql functions | oracle database 11g version 2 |
 
07:19
executed in oracle database 11g version 2
Views: 76 Education 4u
SQL 38, Extract Function ce42
 
01:14
SQL extract function another example
Views: 850 hammadshams
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: 660 Aprenda PL/SQL
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: 18602 ITORIAN
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: 4659 LiveLessons
SQL 38, Extract Function ae42
 
02:16
another example of extract function
Views: 903 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: 34216 The Bad Tutorials
ORACLE SQL  DATE FUNCTIONS
 
05:03
This video shows examples of oracle sql date functions
Views: 1353 SQL TUTORIALS
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: 2530 hammadshams
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: 184 Database Star
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: 1062 WingsOfTechnology
Oracle 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: 12 Ganesh Anbarasu
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: 472 Aprenda PL/SQL
Oracle ROUND: Number function
 
03:48
Oracle TRUNC: Number function https://www.youtube.com/watch?time_continue=3&v=4lchx4sseEM Oracle MOD: Number function https://www.youtube.com/watch?v=eMGgo_1y6b4&feature=youtu.be The usage of SELECT Playlist: https://www.youtube.com/watch?v=ZwgiIiD1dWE&list=PLjBraywgeSpEW2f7AK4Ddt6BRxW0HWN74
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: 2013 Pebbles Tutorials
ORACLE SQL 24: NEXT_DAY, LAST_DAY
 
05:16
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 746 studyandsharevn
TOP 25 SQL Interview Questions 2017
 
03:36
TOP 25 SQL Interview Questions
Views: 470 SQL Guru
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: 601 Aprenda PL/SQL
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: 4149 Lecture Snippets
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: 91222 Manish Sharma
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: 19855 The Bad Tutorials
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
add months in sql
 
02:03
Views: 68 asim
คำสั่ง 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: 352 Akira Shoyasu
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: 1259 Kishan Mashru
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: 462 Aprenda PL/SQL
Урок 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
SQL 37 -How to calculate age Part 1
 
05:05
Structured Query Languge
Views: 6355 hammadshams
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: 416 Aprenda PL/SQL
Learn MySQL In Arabic #31 - Numeric Functions - Mod, Truncate, Pow
 
14:30
Learn Math properties and numeric functions with examples Mod Truncate Pow
Views: 4284 Elzero Web School
Lecture 12 - Playing with Functions in MYSQL for class XII By Tech Shubham
 
07:39
This series of tutorials will include the mysql tour in which i will be covering the topics like - - Database - Database Management system - Advantages -Introduction to mysql - Practicals on mysql etc etc If you have any questions kindly comment below i will try to answer ASAP. If you like then click the hit button and subscribe for more upcoming videos. JAVA TOUR - https://www.youtube.com/playlist?list=PLSfFWwQt_FhBhoIqyrXiiDp0rgt3mklJz IT Applications for Class XII - https://www.youtube.com/playlist?list=PLSfFWwQt_FhBoljDotHuLltbpRYYYH89a Mysql Tour for Beginners - Class XII Information Practices - https://www.youtube.com/playlist?list=PLSfFWwQt_FhCko7ojHehqBJF3X64t6KDx Web App Development - https://www.youtube.com/playlist?list=PLSfFWwQt_FhAaMg8gglStPsq7nzuyB94C For sponsorship and Other Relations Kindly Contact [email protected] Regards Shubham Bharadwaj
Introduccion al lenguaje SQL - Las funciones SYSDATE, MONTHS BETWEEN y otras (27)
 
02:29
En el curso de sql gratuito hoy es el turno de las funciones SYSDATE, MONTHS BETWEEN, ADD_MONTHS, NEXT_DAY y LAST_DAY. Todo el contenido del curso de lenguaje SQL para bases de datos Oracle está disponible en http://cursodelenguajesql.blogspot.com
Views: 1240 Asteriscoo Mas
Tutorial 12 : SQL LPAD() and RPAD()
 
04:58
Hi Friends! Here we are learning about SQL LPAD() and RPAD() function. Let me know for any confusion or doubt. You can mail me or comment in comment box. Email Id - [email protected] Thanks!
Views: 212 YourSmartCode

Rein and n3ds 10/30 pmag california
Cover letter for debt collector resume sample
144 eme newsletter formats
Busse admissions essay
Utep admissions essay samples