SQL Datetime Convert Error -


i have have sql statement returns following error:

the conversion of varchar data type datetime data type resulted in out-of-range value.

select * ebv_platz  (adrid = 4436) , (id <> 5) , (status = 1)   , (convert(datetime, '01.03.2014', 102) >= placefrom)  , (convert(datetime, '01.03.2014')  <= placeto) or (convert(datetime, '31.03.2014') >= placefrom)  , (convert(datetime, '31.03.2014') <= placeto)

but 1 works fine , difference date values:

select * ebv_platz  (adrid = 4436) , (id <> 5) , (status = 1)   , (convert(datetime, '01.01.2000', 102) >= placefrom)  , (convert(datetime, '01.01.2000')  <= placeto) or (convert(datetime, '01.06.2001') >= placefrom)  , (convert(datetime, '01.06.2001') <= placeto)

i don't understand this. can me?

i'm betting second 1 not work fine, rather converts dates january 06 , january 01.

you need give hint using day month year format.

try instead:

(convert(datetime, '31.03.2014', 103)

the 103 (from msdn) interprets date dd/mm/yy

as @alexk noted in comments, these dont need converted. use strings long in better format.

my assumption here using mssql. different platform, syntax different.


Comments

Post a Comment

Popular posts from this blog

Why can rails not find a route created by a helper? -

i created member route in rails 4: resources :line_items post 'decrement', on: :member end and gave matching method in line_items controller: def decrement @cart = current_cart @line_item = @cart.line_items.find_by_id(params[:id]) @line_item.decrement_quantity respond_to |format| if @line_item.save format.html { redirect_to shop_path, notice: 'line item updated.' } format.js {@current_item = @line_item} format.json { head :ok } else format.html { render action: "edit" } format.js {@current_item = @line_item} format.json { render json: @line_item.errors, status: :unprocessable_entity } end end end but when try make button: <%= button_to 'x', decrement_line_item_path(item) %> i error: no route matches [post] "/carts/25" what gives? your error message is: no route matches [post] "/carts/25" but expectin...
Read more

javascript - jquery or ashx not working -

i using ajax file upload control. it creating html: <form action="/pages/handlers/asyncfileuploadhandler.ashx" method="post" enctype="multipart/form-data" target="ajaxuploader-iframe-1397144545"> <input type="hidden" name="type" value="mindvoice"> <input type="file" id="imagefile" style="display: block; width: 80%; margin-right: auto; margin-left: auto;"> </form> and target is: <iframe width="0" height="0" style="display:none;" name="ajaxuploader-iframe-1397144545" id="ajaxuploader-iframe-1397144545"></iframe> the form submitted using .submit() . my ashx handler: <%@ webhandler language="c#" class="asyncfileuploadhandler" %> using system; using system.web; using nettpals.core; public class asyncfileuploadhandler : ihttphandler { public void processre...
Read more

php - Redirect and hide target URL -

i want implement website youtube, these real urls of videos has hidden. when user comes in, , php webpage authenticate user, , redirect user real url of video. problem how can redirect url , hide real video url, or other ways prevent real url of videos exposed? i don't know if got point, looking this? $video_url = $user_is_authenticated ? $video_url : $authentication_url."?returnurl=".$video_url; echo "<a href='$video_url'>video title</a>"; this way, if user authenticated, send him real video url, otherwise login page seen instead. if don't want users see url can use session variables during authentication.
Read more