The SWITCHOFFSET function returns a datetimeoffset value that has been altered from the stored time zone offset to a new time zone offset that has
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Get Date In Multiple Formats in SQL Server
SQL Server has a number of built-in functions that can be used to retrieve the current date in various formats. The following is a list
Connecting Hive in Bitnami
Bitnami Virtual Machines contain a minimal Linux operating system with Hadoop installed and configured. Using the Bitnami Virtual Machine image requires hypervisor software such as VMware
MySQL Temporary Table With Constraints
Temporary tables with constraints and indexes can be created in MySQL. Constraints can be defined even if the temporary table is created without giving column
Create Table With Delimiter and SELECT – Apache Hive
The following example shows how to create a table in Apache Hive with different delimiters, and with and without default location, a text file format
SQL Server Mathematical Functions-2
For the previous post, click here. As stated earlier, mathematical Functions are built-in scalar functions that perform calculations depending on input values provided as arguments
Big Data & SQL 