Date Time formatting in SQL
In this video, we will discuss the most important and most frequently used concept as a Data Engineer. i.e. Date Time formatting in building data pipelines. we will be more regularly converting given dates into different formats and required data will be extracted from the given dates.
#sql #dataengineers #sqlserver #dataanalytics
Here are create and insert statements:
-------------------------------------------------------------
create table employee (
Employeeid int,
EmployeeName varchar(30),
Department varchar(20),
JoiningDate date time,
salary int
)
insert into Employee values(
(1, 'Mahendra', 'Sales', '2023-01-15 09:30:00', 45000),
(2, 'Mahi', 'Marketing', '2022-06-23 10:00:00', 43200),
(3, 'Sai', 'IT', '2021-11-01 11:15:00', 45000),
(4, 'Ravi', 'HR', '2020-09-30 08:45:00', 36000),
(5, 'Suresh', 'Finance', '2019-08-19 14:30:00',54000),
(6, 'Ramesh', 'Operations', '2018-07-10 09:00:00',48000),
(7, 'Lalitha', 'Customer Service', '2023-02-01 13:20:00', 60000),
(8, 'Anil', 'Engineering', '2021-04-15 15:45:00',63360),
(9, 'Vijay', 'Product', '2022-05-21 10:30:00',60000),
(10, 'Krishna', 'Support', '2020-10-05 16:00:00',52800);
You can get more information like data analysis projects and important information from my medium and github pages.
Here are
My medium blogs: / mahendraee204
My github: https://github.com/mahendra204
In questa pagina del sito puoi guardare il video online Date Time formatting in SQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato MeanLifeStudies 01 gennaio 1970, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 343 volte e gli è piaciuto 10 spettatori. Buona visione!
