x
login about faq Site discussion (meta-askssc)
active newest hottest most voted
Questions in topic: date-functions
2
votes
1
answers
59
views

Return record with date with specific time period

Mar 06 at 09:39 PM ThomasRushton ♦ 29.4k
1
votes
0
answers
207
views

mdx: finding the minimum date in each group

Dec 18 '12 at 05:28 AM abhithavva 10
1
votes
2
answers
215
views

Month() and Day() query issues

Oct 11 '12 at 03:54 PM mtevans86 30
0
votes
4
answers
1.6k
views

CAST and CONVERT not working - converting nvarChar to Date

Jun 13 '12 at 12:53 PM Pavel Pawlowski 20.3k
0
votes
1
answers
337
views

adding current date as a parameter to a query block

Jun 01 '12 at 07:33 AM Usman Butt 13.8k
0
votes
0
answers
365
views

[Closed] adding current date as a parameter to a query block

May 31 '12 at 09:59 PM priyank15 342
0
votes
1
answers
418
views

DateAdd problem

Mar 01 '12 at 04:47 PM Kev Riley ♦♦ 46.1k
1
votes
3
answers
648
views

Returning the wrong date

Jul 27 '11 at 12:16 PM sqlLearner 1 542
1
votes
1
answers
348
views

How do I change a date field to a numerica field?

Jun 17 '11 at 12:08 PM Maggie62 11
1
votes
3
answers
774
views

Logic to Handle Weekends

May 12 '11 at 09:03 PM siera_gld 936
0
votes
1
answers
607
views

[Closed] Last weeks data

Mar 24 '11 at 08:15 AM LtDan 305
1
votes
2
answers
2.6k
views

Datediff in where clause

Mar 24 '11 at 07:29 AM tabularyee 160
0
votes
5
answers
2.1k
views

getDate() code for yyyyddmm

Mar 10 '11 at 06:37 AM tabularyee 160
1
votes
3
answers
747
views

DATEDIFF next month

Feb 23 '11 at 10:22 AM Fatherjack ♦♦ 38.8k
1
votes
1
answers
555
views

DATEDIFF used for Month

Feb 17 '11 at 10:50 AM Magnus Ahlkvist 13.7k
1
votes
1
answers
1.8k
views

How to derive exact days, hours and minutes between two dates.

Feb 15 '11 at 01:38 AM Fatherjack ♦♦ 38.8k
1
votes
3
answers
1.2k
views

Getting biweekly periods, start_date and end_date

Dec 31 '10 at 06:20 AM Yada 11
1
votes
1
answers
518
views

Date Function

Dec 07 '10 at 10:18 PM ThomasRushton ♦ 29.4k
1
votes
1
answers
394
views

using DATEADD with a custom calendar

Nov 05 '10 at 04:29 AM Fatherjack ♦♦ 38.8k
1
votes
4
answers
870
views

Generate date ranges from existing date ranges

Sep 23 '10 at 12:16 AM WilliamD 25.3k
0
votes
2
answers
1.7k
views

how to find the given date is a first sunday or monday and so on

Sep 21 '10 at 06:39 AM Fatherjack ♦♦ 38.8k
0
votes
2
answers
4.7k
views

How to convert DD/MM/YYYY to YYYYMMDD ?

Jun 23 '10 at 12:39 AM michelle 41
1
votes
1
answers
2k
views

Compare two date columns in same table

May 29 '10 at 09:08 AM Fatherjack ♦♦ 38.8k
0
votes
2
answers
1.1k
views

how to convert char value to datetime

May 22 '10 at 04:32 AM Fatherjack ♦♦ 38.8k
2
votes
1
answers
1k
views

Using different values within a DATEADD statement

Apr 13 '10 at 05:37 PM Andy 1 23
2
votes
2
answers
2.5k
views

Calculate last 6 months

Mar 22 '10 at 02:29 PM Chris Rolfe 21
2
votes
3
answers
5.5k
views

Using DATEADD with a variable in SSIS

Mar 12 '10 at 05:12 PM Jason Crider 453
1
votes
2
answers
931
views

How to select all the records based on the datetime and get most recent record based on time

Mar 12 '10 at 10:25 AM Tom Staab 5.8k
1
votes
1
answers
509
views

Variable Dates in Scheculed Jobs

Mar 12 '10 at 08:03 AM Fatherjack ♦♦ 38.8k
4
votes
1
answers
1.4k
views

Convert DateTime to Numeric

Feb 02 '10 at 10:42 AM Fatherjack ♦♦ 38.8k
40 questions
78answers


Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Tags

× 1834
× 913
× 749
× 599
× 340
× 321
× 272
× 224
× 113
× 84
× 83
× 50
× 40
× 29
× 22
× 18
× 17
× 11

1 2 next page »

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.

AnswerHubEnterprise
Social Q&A