Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Integers for Datetime - datediff(week...) doesn't care about datefirst

Language: Layout:
View schema
Execution time: 0 sec, rows selected: 20, rows affected: 10, absolute service time: 0,16 sec 
edit mode |  history 
  
dt
week



1
1900-01-01
0



2
1900-01-02
0



3
1900-01-03
0



4
1900-01-04
0



5
1900-01-05
0



6
1900-01-06
0



7
1900-01-07
1



8
1900-01-08
1



9
1900-01-09
1



10
1900-01-10
1





  
dt
week



1
1900-01-01
0



2
1900-01-02
0



3
1900-01-03
0



4
1900-01-04
0



5
1900-01-05
0



6
1900-01-06
0



7
1900-01-07
1



8
1900-01-08
1



9
1900-01-09
1



10
1900-01-10
1






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development