سال ماه شمسی از میلادی ماه میلادی 1398 فروردین 01/01/1398 2019-03-21 March 1398 اردیبهشت 01/02/1398 2019-04-21 April 1398 خرداد 01/03/1398 2019-05-22 May 1398 تیر 01/04/1398 2019-06-22 June 1398 مرداد 01/05/1398 2019-07-23 July 1398 شهریور 01/06/1398 2019-08-23 August 1398 مهر 01/07/1398 2019-09-23 September 1398 آبان 01/08/1398 2019-10-23 October 1398 آذر 01/09/1398 2019-11-22 November 1398 دی 01/10/1398… Continue reading time
Tag: time
The average for Date or Time in T-SQL
The average for Date or Time in T-SQL: We cannot use the average function (AVG) to average dates or times or date-times. I think the best way for this is to convert the date/time to float with Convert(Float,DateField). This function will return the number of days between the DateField and ‘۱۹۰۰-۰۱-۰۱ ۰۰:۰۰:۰۰’. For example it… Continue reading The average for Date or Time in T-SQL