over 4 years ago
CONVERT() function is basically used to converts an expression of one data type to another data type. This function display date/time data in different formats.
data_type(length):- It is used to specifies the target data type.
expression:- It is used to specifies the value to be converted.
style:- It is used to specifies the output format for the date/time.
In this example we take a style value 108 which defines the following format:
Now use the above style in the following query:
In this example we use the style value 107 which defines the following format:
Mon dd, yy
Now use that style in the following query:
September 23, 2016
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using