sql get latest of 2 datetimes
Solutions on MaxInterview for sql get latest of 2 datetimes by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "sql get latest of 2 datetimes"
Oscar
06 Sep 2017
1SELECT ID,
2 CASE WHEN
3 COALESCE(Date1, '1/1/1973') > COALESCE(Date2, '1/1/1973') -- COALESCE is to ensure comparison works when 1 is nullable
4 THEN Date1
5 ELSE Date2
6 END AS MostRecentDate
7FROM Tablesimilar questions
3 days back in sql serversql select data from last weeksql date between one weekget current month last date in sql serversql query to select records entered in last 24 hoursnumber 2810 2 29 in sql meansselect last 2 characters sqlselect the date 30 days less that the todays date sql requestoracle sql select all days between two dates except weekendssql server select between datetimesql get number of days between two datessql list dates between two datesdate 3 months from today sqlsql get highest date from 3 tabelssql server current date minus 5 yearshow to get number of months between 2 dates sql serverhow to get the date diff of 2 dates in the same fieldin sql servercount number of entires by months sqlsql where last 12 monthssql check if date is between 2 datessql select between two datescomplete date is 1 year or not sql serversql calculate working days between two dates excluding weekends and holidaysdate difference in number of days sql server your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful