140 likes | 174 Views
Explore a wide range of SQL functions for data retrieval, manipulation, conversion, math operations, and more. Enhance your SQL skills with functions like Upper, Dateadd, Abs, and more.
E N D
Agenda • String functions • Case functions • Subtracting functions • Manipulation functions • Other functions • Date time functions • Retrieving functions • Partial retrieving functions • Manipulation functions • Convert functions • Mathematical functions
Case functions • Upper(string) • Lower(string)
Subtracting functions • Left(string , integer) • Right(string , integer) • Substring(string , integer)
Manipulation functions Replace( String, String, String) Reverse(String) Replicate(Sting,Integer)
Other functions • Len(String) • select charindex(String,String,index)
Retrieving functions • getDate() • getUTCDate()
Partial retrieving functions • Day(Date-time) • Month(Date-time) • Year(Date-time)
Manipulation functions • Dateadd (datepart, integer, datetime) • Datediff (datepart,datetime,datetime)
Convert function • Convert (datatype, any type) • Cast (any type as datatype)
Mathematical functions • Abs() • Sin(), Cos(), Tan() • Floor(), Ceiling() • Power(), Log(), log10() • Sqrt(),Square()