-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Maybe I am having a moment of 'afternoon', but can anyone explain why I get
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ')'.
When running
CREATE PROC DisplayDate
(
@DateVar DATETIME
) AS
BEGIN
SELECT @DateVar
END
GO
EXEC DisplayDate GETDATE();
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is it possible to deceive SQL Server to return a different date on GetDate() without actually changing the machine date?
This would be great, since we have a database with old data and I'm trying to test some queries that use getdate().
I can change my machine date but that brings some other problems…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
A very common requirement of developers is to format datetime to their specific need. Every geographic location has different need of the date formats. Some countries follow the standard of mm/dd/yy and some countries as dd/mm/yy. The need of developer changes as geographic location changes. In SQL…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am trying to get date from my implementation of jquery date picker, add it to a string and display the resulting image in my div. Something however is just not working. Can anyone check out the code and have a look at it?
The code is supposed to take the date from date picker, combine it in a…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I'm having some trouble using regular expression to get date in a string.
Example :
string text = "75000+ Sept.-Oct. 2004";
MatchCollection dates = Regex.Matches(text, @"[0-9]{5,}[+][\s](jan|feb|fev|mar|apr|avr|may|mai|jun|jui|jul|jui|aug|aoû|sept|oct|nov|dec)[\.][\-](jan|feb|fev|mar|apr|avr|may|mai|jun|jui|jul|jui|aug|aoû|sept|oct|nov|dec)[\…
>>> More
