Questions in topic: datetime - SQL Server Q&A from the SQL Server Central community

Questions in topic: datetime

votes

answers

176

views

convert to datetime

Mar 27 at 02:54 AM KenJ 12.4k

datetime sql server

votes

answers

162

views

Can you convert datetime to nvarchar inside a case stmt so that you can use sum?

Mar 21 at 06:41 PM sqltiger 130

datetime case-statement sum convert nvarchar

votes

answers

2.5k

views

how to change the date format of sqlserver 2005

Mar 13 at 07:06 AM spandana 0

sql-server-2005 datetime datatypes

votes

answers

282

views

Conversion Error

Mar 12 at 08:32 PM KenJ 12.4k

datetime conversion

votes

answers

393

views

Adding merge replication changed datetime fields to Datetime2(7)

Jan 11 at 12:49 PM WilliamD 25.3k

replication datetime merge

votes

answers

305

views

Please help: How to report next 6 months' rent

Nov 29 '12 at 04:07 AM KenJ 12.4k

sql-server-2005 datetime

votes

answers

370

views

SSIS package and SQLDateTime Overflow

Oct 17 '12 at 09:35 PM tombiernacki 318

ssis datetime date

votes

answers

446

views

convert datetime error

Oct 13 '12 at 06:42 PM ThomasRushton ♦ 29.5k

stored-procedures datetime

votes

answers

1.9k

views

Update datetime by one year on sql database

Aug 29 '12 at 12:32 PM ThomasRushton ♦ 29.5k

datetime time

votes

answers

210

views

Need to get date and time in format of 20120817133600

Aug 18 '12 at 06:39 PM SirSQL 4.6k

datetime

votes

answers

728

views

Error calling MSSql Stored Proc from WebService with DateTime

Jul 19 '12 at 06:13 AM Usman Butt 13.8k

datetime .net mssql

votes

answers

1.3k

views

Conversion failed when converting datetime from character string error

Jun 28 '12 at 06:01 PM aross 0

datetime conversion

votes

answers

1.6k

views

CAST and CONVERT not working - converting nvarChar to Date

Jun 13 '12 at 12:53 PM Pavel Pawlowski 20.3k

datetime date-functions

votes

answers

648

views

error Conversion failed when converting date and/or time from character string.

May 18 '12 at 07:39 AM ThomasRushton ♦ 29.5k

datetime cast-convert

votes

answers

624

views

error Conversion failed when converting date and/or time from character string.

May 18 '12 at 04:38 AM robbin 1.6k

stored-procedures datetime

votes

answers

668

views

I need help in converting the hh:mm:ss to 00:00:00 or getting rid of the hh:mm:

May 17 '12 at 02:32 PM cdurham 230

datetime cast-convert

votes

answers

597

views

Convert Datetime

May 17 '12 at 12:58 PM ThomasRushton ♦ 29.5k

datetime

votes

answers

495

views

How do you cast/convert/ or change parts of a datetime field without changing it to a varchar?

May 01 '12 at 07:09 AM Kev Riley ♦♦ 46.1k

datetime dateformat

votes

answers

views

,How to convert datetime to UTC datetime?

Apr 18 '12 at 07:28 PM JohnM 4.5k

datetime utc

votes

answers

1.1k

views

Change start day of week for weekly intervals in charts

Feb 16 '12 at 03:16 PM CFlowers 0

reporting datetime

votes

answers

1.2k

views

Is it possible to insert a datetime/timestamp column on a replicated table?

Feb 14 '12 at 12:52 PM Usman Butt 13.8k

datetime

votes

answers

4.4k

views

Handling updation of datetime column with null value

Feb 01 '12 at 11:21 PM Oleg 15.4k

datetime

votes

answers

603

views

SQL CONVERT datatime failure

Jan 20 '12 at 12:15 AM Kev Riley ♦♦ 46.1k

sql datetime convert

votes

answers

641

views

DateTime to Small Datetime

Dec 21 '11 at 06:01 AM Usman Butt 13.8k

ssis datetime cast-convert

votes

answers

757

views

Datetime Insert Error

Nov 08 '11 at 08:32 AM sqlnewb 216

sql-server-2008 t-sql datetime

votes

answers

664

views

Not DISTINCT

Nov 02 '11 at 09:00 AM Alisdair 13

datetime

votes

answers

views

epoch datetime conversion

Sep 29 '11 at 12:29 PM priyank15 342

datetime conversion

votes

answers

1.3k

views

Nvarchar conversion changing datetime from style 120 to 109

Sep 16 '11 at 11:41 AM Kev Riley ♦♦ 46.1k

sql-server-2005 datetime cast-convert

votes

answers

415

views

How to elminate seconds

Aug 04 '11 at 12:15 PM sqlLearner 1 542

sql datetime

votes

answers

896

views

string to datetime

Jul 28 '11 at 03:41 PM technette 847

datetime

votes

answers

328

views

Date Time Default Value

Jun 27 '11 at 04:19 AM Mohan Kumar 204

datetime

votes

answers

804

views

Storage of DATETIME column

Jun 09 '11 at 06:37 AM Raj More 1.7k

datetime datatypes

votes

answers

998

views

SQL - 24 hour window between dates

May 11 '11 at 10:53 AM kmiura 13

datetime

votes

answers

520

views

Error when converting datetime from character string

Feb 24 '11 at 03:45 PM ThomasRushton ♦ 29.5k

datetime string convert

votes

answers

773

views

Date time in SQL Server

Feb 23 '11 at 06:01 AM NAmola 123

datetime

votes

answers

1.7k

views

Forward slash in character string

Feb 18 '11 at 12:05 PM dabeacon 11

datetime string convert

votes

answers

views

Dates in SQL 2008 backend and Access Frontend

Feb 07 '11 at 12:04 PM csb 13

sql-server-2008 datetime access dateformat

votes

answers

670

views

Character to Date Conversion keeps failing???

Jan 26 '11 at 07:01 AM Fatherjack ♦♦ 38.8k

sql-server-2005 datetime cast-convert

votes

answers

1.2k

views

Setting prior periods based on the current date for use in stored procedure

Jan 03 '11 at 11:51 AM Tim 31.5k

t-sql datetime

votes

answers

456

views

Substring and adding dates

Dec 15 '10 at 11:33 AM Fatherjack ♦♦ 38.8k

datetime

votes

answers

523

views

Date Function

Dec 07 '10 at 10:18 PM ThomasRushton ♦ 29.5k

datetime date-functions

votes

answers

1.7k

views

Convert varchar to Datetime

Nov 21 '10 at 04:32 PM technette 847

datetime

votes

answers

1.9k

views

Converting numeric to datetime

Nov 04 '10 at 05:23 PM Kev Riley ♦♦ 46.1k

t-sql datetime cast-convert

votes

answers

470

views

DATETIME millisecs cannot be relied on

Oct 25 '10 at 10:43 AM Doiremik 71

datetime

votes

answers

1.4k

views

Selecting multiple ranges from a set of dates

Jul 28 '10 at 07:20 PM James Hurburgh 3

t-sql query datetime

votes

answers

476

views

SQL Server 2008 Date

Jul 10 '10 at 09:52 AM netsailer76 1

sql-server-2005 datetime

votes

answers

453

views

Date Problem in SQl Server 2005

Jul 06 '10 at 06:04 PM TechAbhi 1

sql-server-2005 datetime

votes

answers

5.7k

views

conversion of char data type to a datetime data type resulted in out-of-range

Jun 11 '10 at 12:53 PM Kev Riley ♦♦ 46.1k

sql-server-2005 datetime cast-convert data-conversion

votes

answers

1.1k

views

How To Convert UTC or GST to Local Time

Jun 07 '10 at 08:51 AM kathir 1

sql-server-2005 datetime

votes

answers

views

how to compare time in sqlserver2008

Jun 01 '10 at 06:19 AM Kev Riley ♦♦ 46.1k

sql-server-2008 t-sql datetime datatypes

84 questions

171answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags