SQL test

Sql code posted by anonymous
created at 24 Dec 08:54, updated at 13 Jan 07:02

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
IF( WEEKDAY( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) ) >3, (
  YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) )
  AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) <3 )
  OR (
    YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_SUB( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) , INTERVAL 1 WEEK ) )
    AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) >2
  ), (
    YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_SUB( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) , INTERVAL 1 WEEK ) )
    AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) <3
  )
  OR (
    YEARWEEK( FROM_UNIXTIME( orddateshipped ) ) = YEARWEEK( DATE_SUB( DATE_ADD( NOW( ) , INTERVAL +10 HOUR ) , INTERVAL 2 WEEK ) )
    AND WEEKDAY( FROM_UNIXTIME( orddateshipped ) ) >2
  )
)
812 Bytes in 2 ms with coderay