All Questions
Tagged with datetime sql-server-2008-r2
10 questions
0
votes
1
answer
949
views
How can I get the last second of the last month as a default parameter value?
I am trying to get the last second of the last month as a default value for a parameter. I can get the last day of the last month from this query on social.msdn.microsoft.com
last month last day ...
- 365
0
votes
1
answer
2k
views
Microsoft SQL Server 2008+ TIMESTAMP problem
I'm currently facing a Problem, where the SQL Server refuses my Timestamps.
I am accessing the Server via EclipseLink (Java) but this shall not be the problem, as i can test the queries on the Server ...
- 445
1
vote
1
answer
758
views
Convert rfc822 to either a GMT DATETIME or Unix timestamp in SQL Server
I am trying to find a way to convert an rfc822 string date (with timezone) to either a GMT value of data type DATETIME or a unix timestamp of data type INT. For example:
Mon, 15 Aug 2016 11:36:36 UTC
...
- 2,837
0
votes
1
answer
738
views
Converting date string to SQL DATETIME - hopefully without a udf
I am taking an Excel file that has dates in different formats but one of these formats is giving me some grief when I try converting it or casting it to a SQL DATETIME. For example:
Thu Oct 16 13:40:...
- 337
3
votes
1
answer
1k
views
How to find number of days since beginning of fiscal month?
This relates to my question How to find XXth day of previous month in SQL server?
The fiscal month starts on 26th of each month.
I need to find out from any date:
The date of the start of the ...
- 255
3
votes
1
answer
7k
views
How to find XXth day of previous month in SQL server?
I have 2 parameters,
an input date (DATETIME)
input day of month (TINYINT)
If I enter 11 MAR 2014 as the DATETIME and 26 as the input day of month, I would like to select 26 FEB 2014 as the output ...
- 255
4
votes
2
answers
5k
views
Display posted on date and time like1 hr ago or 30 min ago
I want to show the posted date like 1 hr ago, or 30 min ago. This is my code:
declare @date datetime ='2014-07-24 11:50:22.033';
SELECT CASE WHEN DATEPART(DD,@date)=DATEPART(DD,GETDATE()) THEN
...
- 85
5
votes
2
answers
3k
views
Why does SQL Server 2008 R2 insert an invalid datetime when using bulk insert?
I want to insert rows with an optional datetime value (per row) using T-SQL BULK INSERT
on a SQL Server 2008 R2.
A table could look like this:
CREATE TABLE [dbo].[tbl_bulk_insert_datetime_issue] (
...
- 84
3
votes
2
answers
40k
views
Should I join datetime to a date using cast or range?
This question is a take-off from the excellent one posed here:
Cast to date is sargable but is it a good idea?
In my case, I am not concerned with the WHERE clause but in joining to an events table ...
- 1,693
0
votes
1
answer
2k
views
Extract time portion of Datetime2(7) in hhmmssfff format
I need to extract the time portion of a datetime2(7) column in hhmmssfff format and I am doing it like this:
DECLARE @mdate AS DATETIME2(7)
SET @mdate = '2012-03-15 10:13:27.5437431'
SELECT LEFT(...
- 337