sql server - Conversion failed when converting datetime from character string while procedure execution -

-

i need favor on resolve conversion issue.the code have 

alter procedure [workflow_app].[diagnosiscd_car]         @v_monthstr    char ,         @v_monthend    char ,         @v_year        char ,         @v_state_cd    char ,         @v_claim_key   char ,         @v_contractor  char  declare @v_makedatestr   varchar(10) declare @v_makedateend   varchar(10)  select @v_makedatestr  = '01-' + @v_monthstr + '-' + @v_year select @v_makedateend  = '01-' + @v_monthend + '-' + @v_year   select @v_datebegin  = convert(datetime, @v_makedatestr,105)----error select @v_dateend  = dateadd(d, -day(dateadd(m, 1, convert(datetime, @v_makedateend ,105))), dateadd(m, 1, convert(datetime, @v_makedateend ,105)))---error

this code formed using tool , changed somewhere manual.

i getting

'conversion failed when converting datetime character string.'

at "error" comment.

i tried using convert, cast functions unable resolve.

any 1 suggest error , write appropriate conversion code error.

i converting oracle stored procedure sql server 2005.

i using sql server management studio express 2005.

what wrong above code , correct code ?

any code ? ????////// correct conversion

the way converting string datetime can lead different results in case run script in server different culture related settings.

for datetime(s) string, recommend follow rule of building string starting year, month, , on... yyyy-mm-dd.

select @v_makedatestr  = @v_year + '-' + @v_monthstr + '-01'  select @v_makedateend  = @v_year + '-' + @v_monthend + '-01'

then cast:

cast(@v_makedatestr datetime); cast(@v_makedateend datetime);

Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more