AppDividend
Latest Code Tutorials
Browsing Category

SQL

SQL is a standard language for storing, manipulating and retrieving data in databases.

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

SQL PI Function Example | PI in SQL

SQL PI function is used for returning the mathematical value of the constant π (pie). The PI() function returns the value of PI. SQL PI PI is a mathematical constant number to represent the ratio of a circle’s circumference to its…

SQL DEGREES() Function Example

SQL DEGREES() is an inbuilt function that is used to convert a value from radians to degrees. Here, the angle (in radians) is provided as an input to the function and the function will return the value in degrees. The SQL DEGREES() function…

SQL Exp Function Example

SQL EXP() is an inbuilt function that is used for finding the exponent of a float_expression specified. The exponent of the number is the constant e raised to the power of the number. The base of natural logarithms is e (2.718281…), which…

SQL GETUTCDATE Function Example Tutorial

SQL GETUTCDATE is an inbuilt function that is used for returning the current database date and time in UTC format, i.e. in a 'YYYY-MM-DD hh:mm:ss.mmm' format. The GETUTCDATE() function returns the current UTC. The GETUTCDATE() function…

SQL GETDATE Function Example

SQL GETDATE function is used to return the current system TIMESTAMP as a DATETIME value without the database time zone offset. The value is derived from the Operating System of the server on which the instance of SQL Server is running at…

SQL SYSDATETIME Function Example

SQL SYSDATETIME is an inbuilt function Date Function that is used to return the Current Date and Time of the system, i.e. DATETIME2, on which the SQL Server instance is running. The SYSDATETIME() function has more fractional seconds…

SQL SOUNDEX Function Example Tutorial

SQL SOUNDEX is an inbuilt function that accepts the string and returns the phonetic expression, i.e., converts it into four-character code based on how the string sounds when spoken.  The SOUNDEX() function returns the four-character code…