sql server 2008 - SQL: Error when trying to filter out all dates older than the current date -

-


sql server 2008 - SQL: Error when trying to filter out all dates older than the current date -

i'm using sql server 2008. have table stores dates in datetime format (i.e.2012-01-21 15:00:00.000)

i'm trying filter out dates older "today". attempting using query below.

select date mytable date >= getdate()

when run though, next error.

conversion failed when converting date and/or time character string.

is there i'm doing wrong? help , allow me know if need provide more information!

more information:

[date] of type datetime in mytable.

i have view selects [date] , no manipulation

i'm accessing [date] via view

you don't locale in will matter. possibility date column isn't datetime. don't locale in, (as example) , uk datetime formats treated differently when in reverse format.

uk sees date yyyy-dd-mm hh:mm:ss.fff sees date yyyy-mm-dd hh:mm:ss.fff

for example, throws error:

set language british go select cast ('1999-01-21 10:11:12.345' datetime) go

however if alter locale us_english, parse correctly.

if want gurantee it's going parsed yyyy-mm-dd, need strict , utilize total iso spec specifying z between date , time, e.g.,: 1999-01-21z10:11:12.345 parse in same way in both locales.

ultimately, want alter date column datatype of datetime, may need temporarialy alter locale able sucessfully; i.e.:

set language us_english go alter table [...] go set language british go

yet fun 'gotcha' watch out when manipulating date/time data.

sidenote: no don't know why microsoft think on in blighty see date yyyy-dd-mm ... i've never encountered format. inherited european formats?

sql sql-server-2008 datetime date

Comments

Post a Comment

Popular posts from this blog

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

c++ - compiler errors when initializing EXPECT_CALL with function which has program_options::variables_map as parameter -

-
c++ - compiler errors when initializing EXPECT_CALL with function which has program_options::variables_map as parameter - i'm having problem expect_call method, when trying : boost::program_options::variables_map vm; mymock mock; expect_call(mock, mymethod(vm)).willonce(return(l"")); mymethod looks : std::wstring mymethod(const boost::program_options::variables_map &vm) when compiling got errors : error 17 error c2676: binary '==' : 'const boost::program_options::variable_value' not define operator or conversion type acceptable predefined operator c:\program files (x86)\microsoft visual studio 9.0\vc\include\utility error 10 error c2784: 'bool std::operator ==(const _elem *,const std::basic_string<_elem,_traits,_alloc> &)' : not deduce template argument 'const _elem *' 'const boost::program_options::variable_value' c:\program files (x86)\microsoft visual studio 9.0\vc\include\u...
Read more

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