No announcements
Found 1947705 threads
-
0 VotesSimple SQL Date Question
It is easy to fix the query I posted by stripping the date portion of the current date.Answered | 7 Replies | 1371 Views | Created by Jumpy99 - Sunday, April 7, 2013 2:42 PM | Last reply by Naomi N - Monday, April 8, 2013 1:11 PM
-
1 Votes
sql query date
= the current date and < the next date, for example select * from deposit where date>='20090101' and dateAnswered | 4 Replies | 4933 Views | Created by Ksnk - Wednesday, April 6, 2011 1:15 PM | Last reply by Tom Cooper - Wednesday, April 6, 2011 1:24 PM -
4 Votes
sql query between dates
since John is doing an excellent job of helping you straighten out your code, I'll post these 2 links for SQL query formats that I've found ...Answered | 16 Replies | 8529 Views | Created by xp_user33 - Tuesday, March 23, 2010 8:41 PM | Last reply by jtorrecilla - Wednesday, March 24, 2010 11:56 AM -
4 Votes
SQL Query Date Formatting
As I am building a report presentation using Birt I looked into expression builder which I am currently looking at ways of formatting the date field at the frontend not ...Answered | 9 Replies | 905 Views | Created by vinnie_Phantom - Wednesday, August 8, 2018 3:25 PM | Last reply by Visakh16 - Thursday, August 9, 2018 10:56 AM -
0 Votes
sql query for date between
DATEADD(DD,-1,YOUR-DATE-HERE)Answered | 6 Replies | 2658 Views | Created by velsamy ananthavelu - Monday, September 10, 2012 7:36 AM | Last reply by Johnny Bell Jnr - Tuesday, September 11, 2012 10:37 AM -
0 Votes
Querying dates in SQL and formating
Do you know that your solution is not SARGable as it prevents from SQL Server using an index defined on the table?????Answered | 19 Replies | 2704 Views | Created by MrFlinstone - Wednesday, August 24, 2011 8:49 AM | Last reply by Kalman Toth - Wednesday, August 24, 2011 7:30 PM -
0 Votes
SQL Date Query
https://docs.microsoft.com/en-us/sql/t-sql/functions/eomonth-transact-sql?Answered | 5 Replies | 2684 Views | Created by moses004 - Wednesday, May 30, 2018 3:34 PM | Last reply by Xi Jin - Thursday, May 31, 2018 2:25 AM -
0 Votes
SQL Query with Dates
Looks like the error message doesn't just drop the "AND" from the SQL but also could not resolve the variables dtStart and dtEnd.Answered | 4 Replies | 417 Views | Created by Raabi2 - Sunday, August 28, 2016 3:38 PM | Last reply by .theDBguy - Sunday, August 28, 2016 4:50 PM -
0 Votes
Query Date Criteria Question
Yes, but Date Due: DateAdd("d",[Date@Install],[RDOP]) wrong.Answered | 2 Replies | 2032 Views | Created by PhilthyM - Tuesday, January 24, 2012 4:21 AM | Last reply by QA Guy CommElec - Tuesday, January 24, 2012 5:38 AM -
4 Votes
SSIS - Passing a date parameter to a SQL Query question again....
It seems that the variable method did not like the carriage return line feeds in my query so I just made one giant long query line.Answered | 8 Replies | 11351 Views | Created by Stupid48 - Tuesday, October 19, 2010 7:13 PM | Last reply by avinashs13 - Wednesday, May 8, 2013 4:43 AM -
0 Votes
date format in sql query
I'll add to this - use the date datatype if your value is intended to be a date only.Answered | 2 Replies | 3338 Views | Created by hygrsrir1987 - Wednesday, December 19, 2012 9:19 AM | Last reply by scott_morris-ga - Wednesday, December 19, 2012 2:31 PM -
0 Votes
Question about SQL Query
In other words, check if both queries are using variables for the same things, parameters for the same thing, literals for the same things, and that the rest of the query is also ...Answered | 6 Replies | 1252 Views | Created by Agile World - Tuesday, July 30, 2013 7:30 PM | Last reply by Chris Sijtsma - Wednesday, July 31, 2013 11:18 AM -
0 Votes
SQL Query for Date Check User Dates
Thnks Abbas,, I want Another one, Need SQL Query For Following Thread...Answered | 11 Replies | 7160 Views | Created by Riyajudeen - Tuesday, September 28, 2010 12:03 PM | Last reply by Riyajudeen - Friday, October 1, 2010 5:05 AM -
4 Votes
Date Query
So try the following:Answered | 7 Replies | 2042 Views | Created by SurfGitmo - Wednesday, February 29, 2012 3:50 PM | Last reply by Matthew Slyman - Thursday, March 1, 2012 9:06 AM -
0 Votes
SQL Date Query
I'll try to include it in the query Thanks Naom :)Answered | 7 Replies | 3889 Views | Created by SQLUser1979 - Tuesday, December 21, 2010 4:09 PM | Last reply by SQLUser1979 - Tuesday, December 21, 2010 7:26 PM -
0 Votes
SQL query question
date column with is a sequence starting at some original date (say 2000-01-01 these days).Answered | 7 Replies | 2432 Views | Created by keya_guin - Tuesday, March 20, 2012 4:40 PM | Last reply by MichaelMeierruth - Wednesday, April 11, 2012 9:49 AM -
0 Votes
SQL QUERY(DATE FUNCTIONS)
Here you go Declare @GivenDate datetime = '2016-06-22' SELECT CONVERT(VARCHAR(10),DATEADD(DAY, -3, DATEADD(WEEK, DATEDIFF(WEEK, 0, @GivenDate), 0)),121) ...Answered | 1 Replies | 592 Views | Created by santoshkum - Wednesday, June 22, 2016 8:25 AM | Last reply by senthilswing - Wednesday, June 22, 2016 11:23 AM -
1 Votes
SQL date time query
SELECT Dateadd(day,-2,DATEADD(week, DATEDIFF(week,0,'2018-06-29')-1,0 )) as [start date] SELECT Dateadd(day,-3,DATEADD(week, DATEDIFF(week,0,'2018-06-29'),0 )) as [end ...Answered | 5 Replies | 732 Views | Created by Arav_ind - Tuesday, June 26, 2018 6:04 AM | Last reply by Jingyang Li - Tuesday, June 26, 2018 1:36 PM -
2 Votes
SQL Query with group by on date
You forgot to put Date into an aggregate function.Answered | 6 Replies | 2930 Views | Created by Abhiyanta - Tuesday, July 2, 2013 6:14 AM | Last reply by Abhiyanta - Tuesday, July 2, 2013 6:14 PM -
0 Votes
SQL Query modified to include a date range instead of a single date.
The query itself I posted is correct and I hope that MS Query SP2 should recognize it OK.Answered | 8 Replies | 1239 Views | Created by Scott Horner - Monday, September 9, 2013 4:38 PM | Last reply by Naomi N - Monday, September 9, 2013 6:43 PM - Items 1 to 20 of 1947705 Next ›
No announcements
