asked on
SQL Server: DateTime column in select
SQL Server DateTime column
how to display only date part in select?
and how to display empty value instead of NULL, and also not 1900-01-01 ?
SQLMicrosoft SQL Server
Last Comment
arnold
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
usually, if the column is defined as datetime(), you would use the 1-1-1901 as the default value mining NULL/EMPTY.
you can use the datediff to assess or use that info in your query.
it is common that vendor use the 1-1-1901 as a null date or they use a date that is more than a 100 years from the software design depending on what the date is for, i.e. you might se 1-1-1901 currently it accounts for people whose age is approaching 120.
you can use the datediff to assess or use that info in your query.
it is common that vendor use the 1-1-1901 as a null date or they use a date that is more than a 100 years from the software design depending on what the date is for, i.e. you might se 1-1-1901 currently it accounts for people whose age is approaching 120.
One option is to use case and substring (column_name,0,10)
Try the following, to convert it to Varchar. The following does also convert it to the current date time if it is null.
Open in new window