010 MySQL: Distinct Keyword, Scalar Functions: Date, and Conversion Functions.
In this Lecture, we will study MySQL: Distinct Keyword, Scalar Functions: Date, and Conversion Functions.
---DATE_ADD(date, INTERVAL expr type);
list of exprtype
MICROSECOND
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR
SECOND_MICROSECOND
MINUTE_MICROSECOND
MINUTE_SECOND
HOUR_MICROSECOND
HOUR_SECOND
HOUR_MINUTE
DAY_MICROSECOND
DAY_SECOND
DAY_MINUTE
DAY_HOUR
YEAR_MONTH
------------------------------------------------------------------------------------------------------------------------------
--- DATE_FORMAT(date,format);
list of formats
%a-Abbreviated weekday name (Sun-Sat)
%b-Abbreviated month name (Jan-Dec)
%c-Month, numeric (0-12)
%D-Day of month with English suffix (0th, 1st, 2nd, 3rd)
%d-Day of month, numeric (00-31)
%e-Day of month, numeric (0-31)
%f-Microseconds (000000-999999)
%H-Hour (00-23)
%h-Hour (01-12)
%I-Hour (01-12)
%i-Minutes, numeric (00-59)
%j-Day of year (001-366)
%k-Hour (0-23)
%l-Hour (1-12)
%M-Month name (January-December)
%m-Month, numeric (00-12)
%p-AM or PM
%r-Time, 12-hour (hh:mm:ss followed by AM or PM)
%S-Seconds (00-59)
%s-Seconds (00-59)
%T-Time, 24-hour (hh:mm:ss)
%U-Week (00-53) where Sunday is the first day of week
%u-Week (00-53) where Monday is the first day of week
%V-Week (01-53) where Sunday is the first day of week, used with %X
%v-Week (01-53) where Monday is the first day of week, used with %x
%W-Weekday name (Sunday-Saturday)
%w-Day of the week (0=Sunday, 6=Saturday)
%X-Year for the week where Sunday is the first day of week, four digits, used with %V
%x-Year for the week where Monday is the first day of week, four digits, used with %v
%Y-Year, numeric, four digits
%y-Year, numeric, two digits
-------------------------------------------------------------------------------------------------------------------
CAST(expression AS datatype)
list of datatypes
DATE
DATETIME
TIME
CHAR
DECIMAL
SIGNED
UNSIGNED
BINARY
#DatefunctionsinSQL #ScalarFunctionsinSQL #DistinctKeywordinSQL Our Social Media:
► Subscribe to us on YouTube- / @c4knowledgeseekers
► Like Our Page on Facebook: / c4knowledgeseekers
► Follow us on Instagram: / c4knowledgeseekers
► Website: http://www.c4knowledgeseekers.in
►BCA PU papers: https://play.google.com/store/apps/de...
---------------------------------------------------------------------------------------------------------------------------------------
#C4KNOWLEDGESEEKERS #COMPLETEDIGITALSERIES #UGCNET #GATE #NTANET
--------------------------------------------------------------------------------------------------------------------------------------
Other subject playlist Link:
--------------------------------------------------------------------------------------------------------------------------------------
►C LANGUAGE:
• Learn C Language with Examples
►DATA STRUCTURES:
• DATA STRUCTURES USING C
►DATABASE MANAGEMENT SYSTEM:
• DATABASE MANAGEMENT SYSTEM
►PL/SQL using oracle:
• PL/SQL using Oracle
►MySQL:
• MySQL
►FUNDAMENTALS OF WEB PROGRAMMING: HTML, CSS, JAVASCRIPT
• HTML Website Development Tutorials | Learn...
►CSS:
• CASCADING STYLE SHEETS 3: COMPLETE TUTORIA...
►BOOTSTRAP 4: COMPLETE TUTORIALS:
• BOOTSTRAP 4: COMPLETE TUTORIALS
►PHP: Hypertext Preprocessor COMPLETE TUTORIALS
• PHP: Hypertext Preprocessor COMPLETE TUTOR...
►CORE JAVA LANGUAGE:
• CORE JAVA LANGUAGE LIVE LECTURES
►Multithreading in Java:
• MULTITHREADING in JAVA
►J2EE: ADVANCED JAVA COMPLETE TUTORIALS
• J2EE: ADVANCED JAVA COMPLETE TUTORIALS
►COMPUTER ALGORITHMS:
• COMPUTER ALGORITHMS (DESIGN AND ANALYSIS)
►THEORY OF COMPUTATION:
• THEORY OF COMPUTATION
►OPERATION RESEARCH: COMPLETE TUTORIALS
• OPERATION RESEARCH: COMPLETE TUTORIALS
►COMPUTER ARCHITECTURE: COMPLETE TUTORIALS
• COMPUTER ARCHITECTURE: COMPLETE TUTORIALS
►DISCRETE MATHEMATICS: COMPLETE TUTORIALS
• DISCRETE MATHEMATICS: COMPLETE TUTORIALS
►OPERATING SYSTEM: COMPLETE TUTORIALS
• OPERATING SYSTEM: COMPLETE TUTORIALS
►GOOGLE JAMBOARD: COMPLETE TUTORIAL:
• GOOGLE JAMBOARD: COMPLETE TUTORIAL
►GOOGLE CLASSROOM: COMPLETE TUTORIAL:
• GOOGLE CLASSROOM: COMPLETE TUTORIAL
►GOOGLE FORM: COMPLETE TUTORIALS:
• GOOGLE FORM: COMPLETE TUTORIALS