cast-convert Image

cast-convert

question
JCACERES avatar image
JCACERES commented Default

Convert or cast dates like (Mon Jul 18 19:28:36 EDT 2016) To DateTime

sql cast-convert datetime-formats

This question has an accepted answer. Accepted

0 Likes

1Answer

2 Comments

question
deshazer72 avatar image
deshazer72 answered Default

I am trying to convert a var char time period to numeric

sorting left cast-convert cast

0 Likes

1Answer

0 Comments

question
GPO avatar image
GPO edited Default

Please advise on Arithmetic overflow error converting varchar to data type numeric

select error convert cast-convert overflow

0 Likes

1Answer

0 Comments

question
KenJ avatar image
KenJ commented Default

Convert datetime column to julian date

datetime convert cast-convert

This question has an accepted answer. Accepted

0 Likes

1Answer

2 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

I have to replace this date 12/28/15 **

sql-server-2008 sql-server-2012 convert dates cast-convert

0 Likes

2Answers

1 Comment

question
Infock12 avatar image
Infock12 answered Default

Unable to convert percentage into decimals

sql-server-2012 convert decimal cast-convert

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
jonlellelid avatar image
jonlellelid answered Default

Calculate to show exact result neither rounded up or down

decimal calculations cast-convert

This question has an accepted answer. Accepted

0 Likes

3Answers

0 Comments

question
mahler9 avatar image
mahler9 commented Default

Aggregate datetime from 15-minute increments to single hour

t-sql datetime aggregates cast-convert

This question has an accepted answer. Accepted

1 Like

1Answer

1 Comment

question
udhaya avatar image
udhaya answered Default

Cast dd Mon YYYY to mm/dd/yyyy in SSIS

ssis cast-convert

This question has an accepted answer. Accepted

1 Like

2Answers

1 Comment

question
udhaya avatar image
udhaya edited Default

Create select query how to convert varchar to int by using cast

sql-server-2008 select substring cast-convert

This question has an accepted answer. Accepted

1 Like

3Answers

0 Comments

question
gloing59 avatar image
gloing59 Suspended answered Default

case expression errors in where clause errors

where cast-convert case

0 Likes

5Answers

0 Comments

question
ThomasRushton avatar image
ThomasRushton answered Default

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

datetime cast-convert

0 Likes

1Answer

1 Comment

question
cdurham avatar image
cdurham commented Default

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

datetime cast-convert

This question has an accepted answer. Accepted

0 Likes

1Answer

4 Comments

question
aRookieBIdev avatar image
aRookieBIdev asked Default

SSIS Null value for Integers

ssis null data-conversion cast-convert

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Usman Butt avatar image
Usman Butt edited Default

DateTime to Small Datetime

ssis datetime cast-convert

0 Likes

1Answer

0 Comments

36 Posts
32 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.