sql date conversion | Convert Date format into DD/MM/YYYY format in SQL Server
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.
In this video, we showed the usage of SQL CONVERT function for converting date and time from yyyy/MM/dd to dd/MM/yyyy.
how to convert sql date format?
you can change sql date to any custom format easily,
sql date conversion syntax:
-- CAST Syntax:
CAST ( expression AS data_type [ ( length ) ] )
-- CONVERT Syntax:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
Arguments
expression
Any valid expression.
data_type
The target data type. This includes xml, bigint, and sql_variant. Alias data types cannot be used.
length
An optional integer that specifies the length of the target data type, for data types that allow a user specified length. The default value is 30.
style
An integer expression that specifies how the CONVERT function will translate expression. For a style value of NULL, NULL is returned. data_type determines the range.
Return types
Returns expression, translated to data_type.
Microsoft link for styles and formats:
https://docs.microsoft.com/en-us/sql/...
Hafeez Computers Thakot
#DateConversion
#SQLmanagementStudio
HCT
RDLC Tablix sum error | visual Studio | Report error C#
https://www.youtube.com/watch?v=7iDVp...
how to add Microsoft RDLC Report Designer in Visual Studio C#? ( RDLC file open in XML code Solved)
• how to add Microsoft RDLC Report Designer ...
could not load file or assembly | Microsoft Report Viewer SQL Server | Visual Studio Application https://www.youtube.com/watch?v=iNKga...
An error occurred When attaching the database | MDF file Cannot attach SQL Server Solved https://www.youtube.com/watch?v=dHIRC...
Hafeez Computers Thakot
Javed Ikram