Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
forming date as nvarchar
--forming date as nvarchar in sql server select right('0000' + cast(year(getdate()) as nvarchar), 4)+'-'+ right('0' + cast(month(getdate()) as nvarchar), 2)+'-'+ right('0' + cast(day(getdate()) as nvarchar), 2)+' '+ right('0' + cast(DatePart(Hour, getdate()) as nvarchar), 2)+':'+ right('0' + cast(DatePart(Minute, getdate()) as nvarchar), 2) as date_time
run
|
edit
|
history
|
help
0
Preppin Data Challenge - Week 8
Tabela Hospedes BD
c12part2
First Query
NAMES CODE
Practice
FORMAT FUNCTION (New Feature of 2012 sql server)
https://www.hsbc.co.in/ways-to-bank/online-banking/9247/
Exa
test