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
Nesta página do site você pode assistir ao vídeo on-line Date Time formatting in SQL duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário MeanLifeStudies 01 Janeiro 1970, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 343 vezes e gostou 10 espectadores. Boa visualização!
