Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

select amount weeks between two dates mysql

##syntax: FLOOR(DATEDIFF(DATE(column_end_date), DATE(column_ini_date))/7)

Select FLOOR(DATEDIFF(DATE(20090215), DATE(20090101))/7);
 
PREVIOUS NEXT
Tagged: #select #amount #weeks #dates #mysql
ADD COMMENT
Topic
Name
1+7 =