tsql - Where do I put the CONVERT statement to change DATETIME to just DATE in UPDATE Satement -

-

i have query produces date in datetime format... see below.

update wcv_3 set visit_1= #temp2.[first service date]  wcv_3 join #temp2 on #temp2.universalmemberid= wcv_3.universalmemberid #temp2.visit_cnt= 1

returns this: 2013-01-03 00:00:00.000

what correct convert statement use , place in query return date , not time part?

i want 2013/01/03

update wcv_3 set visit_1= cast(#temp2.[first service date] date) wcv_3 join #temp2 on #temp2.universalmemberid= wcv_3.universalmemberid #temp2.visit_cnt= 1

Comments

Post a Comment

Popular posts from this blog

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

c# - Why won't my code write to SQL? -

-
i'm writing app store texts sql database, code throws exception saying "the variable name @par1 has been declared", i'm not sure how working , fixing if possible please =] offending code below private void smsgetter() { try { decodedshortmessage[] messages = comm.readmessages(phonemessagestatus.all, phonestoragetype.sim); sqlconnection conn = new sqlconnection("data source=*********;initial catalog=********;user id=**********;password=***********"); sqlcommand com = new sqlcommand(); com.connection = conn; conn.open(); foreach (decodedshortmessage message in messages) { //com.commandtext = ("insert smsarchives(message,blacklist) values ('" + message.data.userdatatext + "', 'yes')"); //com.executenonquery(); com.commandtext = (...
Read more

c# - Avoiding duplicate methods for Task and Task<T> -

-
i have logic task , task<t> . there way avoid duplicating code ? my current code following: public async task<socialnetworkuserinfo> getme() { return await wrapexception(() => new socialnetworkuserinfo()); } public async task authenticateasync() { await wrapexception(() => _facebook.authenticate()); } public async task<t> wrapexception<t>(func<task<t>> task) { try { return await task(); } catch (facebooknointernetexception ex) { throw new noresponseexception(ex.message, ex, true); } catch (facebookexception ex) { throw new socialnetworkexception("social network call failed", ex); } } public async task wrapexception(func<task> task) { try { await task(); } catch (facebooknointernetexception ex) { throw new noresponseexception(ex.message, ex, true); } catch (facebookexception ex) { throw new soci...
Read more