sql server - php to call MSSQL query and compare two dates? -

-


sql server - php to call MSSQL query and compare two dates? -

ahoy there all, bit stuck , need help.

i calling external mssql (not mysql) database linux server , display results after today's date. here code:

$today = date("y-m-d");// current date $date = strtotime(date("y-m-d", strtotime($today))); $todaysdate = date( 'm j y g:i:s:000a', $date ); //converts mssql standards $query = "select dateofarrival atable dateofarrival > '". $todaysdate ."'";

when run query, displays results, doesn't give flying hoot where.

i guessing because comparing date string? not sure on 1 though.

any thoughts? give thanks in advance!

update: here echoed query string.

$query = "select dateofarrival atable dateofarrival > 'jan 10 2012 12:00:00:000am'";

date examples stored in db:

feb 28 2004 12:00:00:000am oct 14 2009 12:00:00:000am may 18 2011 12:00:00:000am apr 10 2012 12:00:00:000am

t-sql/mssql uses standard armed forces format, see "m j y g:i:s:000a" format because using software converts output fit locale of scheme or locale of database, i'm not sure one.

what know sure when comparing dates in mssql, in other system, always utilize the

y-m-d g:i:s

format. how databases store info , how expects provided when input or compare.

i've done 5 years of work in vb6 + mssql, confirm sure... nil fancy in vb6, had larn format myself.

php sql-server date

Comments

Post a Comment

Popular posts from this blog

How do I check if an insert was successful with MySQLdb in Python? -

-
How do I check if an insert was successful with MySQLdb in Python? - i have code: cursor = conn.cursor() cursor.execute(("insert new_files (videos_id, filename, " "is_processing) values (%s,%s,1)"), (id, filename)) logging.warn("%d", cursor.rowcount) if (cursor.rowcount == 1): logging.info("inserted values %d, %s", id, filename) else: logging.warn("failed insert values %d, %s", id, filename) cursor.close() fun is, cursor.rowcount always one, though updated database create videos_id unique key. is, insert fails because in tests same videos_id going appear (and when check database, nil inserted). whatever reason, rowcount 1 - logging.warn have spits out rowcount of 1. so, question: can utilize rowcount work out if insert went fine? if so, (presumably) doing wrong? otherwise, how check if insert went fine? your code not commit after modifications (your modifications rolled back). should...
Read more

delphi - blogger via idHTTP : error 400 bad request -

-
delphi - blogger via idHTTP : error 400 bad request - i'm trying post blogger using idhttp component, however, i'm getting "http/1.0 400 bad request" error. procedure tform1.button1click(sender: tobject); var request,response,req : tstringlist; auth,blogid : string; begin blogid := '00000000000000000000000'; request := tstringlist.create; response := tstringlist.create; req := tstringlist.create; idhttp1.request.connection := 'keep-alive'; idhttp1.request.contenttype := 'application/x-www-form-urlencoded'; idssliohandlersocket1.ssloptions.method := sslvsslv23; request.clear(); request.values['accounttype'] := 'google'; request.values['email'] := 'xxx@gmail.com'; request.values['passwd'] := 'yyy'; request.values['service'] := 'blogger'; response.text :=idhttp1.post('https://www.google.com/accounts/clientlogin',request); auth := resp...
Read more

postgresql - ERROR: operator is not unique: unknown + unknown -

-
postgresql - ERROR: operator is not unique: unknown + unknown - i have postgis database , have compute new values rows in new column. these values should average of values of several columns. query: insert bdps (da_m) values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7')); in query bdps database, da_m new column , da_1 da_7 existing columns have double precision type. da_m created using alter table bdps add together column da_m double precision; i next error: error: operator not unique: unknown + unknown line 2: values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7... ^ hint: not take best candidate operator. might need add together explicit type casts. ********** error ********** error: operator not unique: unknown + unknown sql state: 42725 hint: not take best candidate operator. might need add togethe...
Read more