Adi Dotnet: how to find number of weeks between two dates

Pages

Home
React JS
React Native
SQL Server
C#.net
Interview
Videos
Angular
ASP.Net
AJAX
Contact Us

25 December 2013

how to find number of weeks between two dates

SELECT DATEDIFF(wk,'2012-01-01', '2012-01-31')

Posted by adi at 22:02

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Search This Blog

Pages

Popular Posts

Registration form in asp.net using stored procedures

Registration form in asp.net using stored procedures Introduction Here I will explain how to insert data into database tables using...
How to validate 10 digit mobile number in asp.net with regular expression control.

<% @ Page Title ="Home Page" Language ="C#" MasterPageFile ="~/Site.master" AutoEventWireup ="t...
DataList Example Using RepeatColumns,HeaderTemplate & ItemTemplate.

DataList Create Database :- create database student Create Table :- create table student_details(Id int identi...
C# program to print pascal triangle

using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { ...
C# program to count number of spaces and words in a entered string

using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { ...

Translate

Contributors

Adinarayana Reddy JC
Madhan
Navitha JC
adi

Search

Blog Archive

▼ 2013 (256)
- ► February (4)
- ► March (3)
- ► April (1)
- ► May (12)
- ► June (56)
- ► July (30)
- ► August (25)
- ► September (14)
- ► October (31)
- ► November (14)
- ▼ December (66)

► 2014 (325)
- ► January (110)
- ► February (97)
- ► March (37)
- ► April (51)
- ► May (6)
- ► June (12)
- ► July (4)
- ► August (8)

► 2015 (4)
- ► January (3)
- ► February (1)

► 2020 (165)
- ► January (28)
- ► February (70)
- ► March (3)
- ► April (64)

► 2021 (49)
- ► February (3)
- ► March (13)
- ► June (3)
- ► July (6)
- ► August (1)
- ► September (1)
- ► October (3)
- ► December (19)

► 2022 (55)
- ► January (7)
- ► March (4)
- ► July (3)
- ► August (39)
- ► September (2)

Popular Posts

Registration form in asp.net using stored procedures
How to validate 10 digit mobile number in asp.net with regular expression control.
DataList Example Using RepeatColumns,HeaderTemplate & ItemTemplate.
C# program to print pascal triangle
C# program to count number of spaces and words in a entered string

Labels

.net .net core .net framework .net MAUI == 2nd largest 2nd smallest 3 tier Architecture 32 bit 64 bit Absolute layout Access Modifiers accordion Active Directory activity Indicator Adi Dotnet Advantages AJAX alert All databases Android angular App Code Application run Array Array to List Arrow function Arry asp.net Asp.net Core Asp.net routing asp.net web services Aspx page create asyncStorage authentication auto postback Autocomplete Axios back button backup Bar Chart Binary search Bind binding Bootstrap Border BoxView browser Build Configuration button c Sharp c# caching Calculating days Calm Down camma separated Carousel View in MAUI Catch catch blocks Checkbox Circle class class component class library Class Selector clear all text box cli CLS Code snippets Collection View in MAUI Comaring two Datatables Combination Comma Separated Comments Component component life cycle ComponentDidMount ComponentDidUpdate componet Computed columns Confirmation message Const Content Page Control controls Convert Convert Date to Quarter Convert date to Year Cookies copyright Copyright symbol Cors Count Duplicate Create groups Create table Crud css CSS Properties CSS Selectors CTS Currency symbols Current Date current location Custom Header Data Binding Data Fetching Database Database Space Databse mail Dataset Datatable datatype Dataview Date Date picker Date time Date to Month name DateADD DatePicker dates datetime DBML Decimal Number decoding Decrypt Deete duplicate records Default Default Props delegate Delete delimited Detailsview Detect Device Device height Device portrait Device width Difference differences Directory creation Disadvantages Display Alert Dispose Distinct div DomNode Double value drive Drive list dropdown Duplicate duplicate rows Dynamic edit top n rows Editor in MAUI element exists Ellipse email encoding Encrypt English Entity Framework Entity Framework core Entry in MAUI environment Equals Error Handling event Event binding Events excel Exists Expo exponent External CSS favicon Features Fetch Fetch Data FIDO Authentication file creation File Saving File upload size files filter Filters Finally Find First row Flatlist Flex layout Flexbox flyout page focus For Example Form Form Text Area fragment framework 4.0 Function Function component Functional Global temporary table GOOD JOB Grid Grid layout gridview gridview column Horizontal Scroll Horizontal stack layout HTML HTML Class html page HyperLink IAction Method if else IIS IL image Image Button image component Image Example in MAUI Image Icon IMP URLs Infinite loops Inline CSS Inline styles Input control Insert Installation Date int IOS IP itemtemplate JavaScript Join JQuery Jquery Each function Jquery Validation JSON JSON Datatypes JSON IMP URLs JWT Authentication Label landscape largest Last Char Last day of Month last row latitude layout layout types let Line Linq List List View in MAUI live clock Loading Localimage Locat temporary table location logout longitude Loop mail Mainframe Master page Master pages MAUI meta tags model model popup module Month Name in c# Month Number months Mouse hover MS access multiple catch blocks Multiple query string MVC my sql Navigation nearest location nested Network Network status Next Row ng-template ngclass Ngfor ngif ngif-else ngstyle ngSwitch node modules npm null Nullable to not null Number Validation Numeric Key pad OAuth object onchange Online Image OPENID operator Operators oval packages Page refresh Page reload Page title password password to Word file Path Picker Picker in MAUI pipes polygon Polyline popup Postbacks prefix Previous day Previous Row print printer Printers progress bar in maui ProgressBar prop Property binding props Query Query string Radio Button radium React React hook React Hooks React JS React Native react project Reading json rectangle reference type Remove duplicate rows Replace values reusable Reusable Button reverse reverse a number Root view rounded corner router routing RowDatabound SafeAreaView screen height Scroll view ScrollView searchbar in maui Select Select control SELECT statement Select top n rows selected value selectors Sequence number Server controls service Session Session Management Sizeof slide slider smallest Sort sort groups Split SQL SQL Function sql query SQL Server sql sever SSL SSMS stack layout Start time state Stepper in MAUI stored procedure Stored Procedures string string to utf-8 string.split strings Sttring Arry styles Styling Sub Script Substring Subtract Super Scipt Switch Switch in MAUI Tabbed page table Table View in MAUI tables Template Temporary table Ternary Operator Testing Text box Text file Text Length TextArea textbox TextInput Three tables join Time Picker Toggle total number of tables TouchableOpacity trace Transmit security Triangle shape trim two way data binding UDF Unary Operators uninstall SQL Server Unique Unique column Update UseEffect user defined functions User Defined funtions username users usesqlserver usestate Validate validation validators value type var Var datatype Verbs versions Verticalstack layout View ViewBag ViewData Viewstate Visual studio visual studio code Way to offer Help wcf WCF interview question Web API Web Development IMP URL's Web reference web services web.config webmethod website Websites WebView win application Windows Windows 7 Windows Authentication Word xml XUnit years yellow warning box

Theme images by cmisje. Powered by Blogger.