Tema: Re: Performance test results (kb)
Autorius: Laimis
Data: 2010-08-12 16:55:12
Jornada Del Muerto rašė:
> ---------------------------------------------------------------------------------------------------
> -- Best result is: select DateAdd(dd, 0, DateDiff(dd, 0, getDate()))
> ---------------------------------------------------------------------------------------------------

Nesupratau koks tikslas ir prasmė taip daryti, jei laiko dalis lyginant 
datas vistiek nebus naudojama (koks skirtumas ar tai 00:00:00.000
ar 12:12:12.012)?

Datų skirtumo manipuliavimui/gavimui (ten/tada kur/kai to reikia) 
pakanka DATEDIFF (dd, startdate, enddate)  ir tam visiškai nebūtina 
atsikratyti laiko dalies.
3Dastronomyagricultureaudioautosautos.audiautos.audioautos.binariesautos.bmwautos.clubautos.fordautos.hondacrxautos.japanautos.mercedesautos.opelautos.sportautos.volvoautos.vwaviaavia.binariesbankcardsbinariesbooksbuildingcinemacommercecomp.hardwarecomp.softwarecomp.lietuvinimascomp.networksculturedarbas.ieskaudarbas.siulaudesigneconomicselectronicsfaunafauna.aquafauna.binariesfishingflorafotofoto.binariesgamesgames.csgames.onlinegsmgurmanaihumourhumour.binariesinternetlawmicrosoftmotomusicmusic.binariesmusic.instrumentsmusic.LT.binariesnavigacijaphppoliticsprogrammingrpgsportstudyingsveikatatalktesttranslationtransportationtraveltravel.binariestvunixvideovideo.binarieswatersportswwwwww.flashpdaautos.supermama.ltmobiledarbasretro.3Dretro.agricultureretro.astronomyretro.audioretro.autosretro.autos.audiretro.autos.audioretro.autos.binariesretro.autos.bmwretro.autos.clubretro.autos.fordretro.autos.hondacrxretro.autos.japanretro.autos.mercedesretro.autos.opelretro.autos.sportretro.autos.supermamaretro.autos.supermama.ltretro.autos.volvoretro.autos.vwretro.aviaretro.avia.binariesretro.bankcardsretro.beosretro.binariesretro.booksretro.buildingretro.cinemaretro.commerceretro.compretro.comp.hardwareretro.comp.lietuvinimasretro.comp.networksretro.comp.softwareretro.cultureretro.darbasretro.darbas.ieskauretro.darbas.siulauretro.designretro.economicsretro.electronicsretro.e-vejasretro.faunaretro.fauna.aquaretro.fauna.binariesretro.fishingretro.floraretro.fotoretro.foto.binariesretro.gamesretro.games.csretro.games.onlineretro.games.rpgretro.genealogijaretro.gsmretro.gurmanairetro.humourretro.humour.binariesretro.internetretro.YZFretro.YZF.nebukretro.YZF.nebuk.netikintisretro.YZF.nebuk.netikintis.bukretro.YZF.nebuk.netikintis.buk.tikintisretro.lawretro.microsoftretro.mobileretro.motoretro.musicretro.music.binariesretro.music.instrumentsretro.music.LTretro.music.LT.binariesretro.navigacijaretro.newsretro.news.taisyklesretro.newuserretro.pdaretro.phpretro.politicsretro.programmingretro.rpgretro.sportretro.studyingretro.sveikataretro.talkretro.translationretro.transportationretro.travelretro.travel.binariesretro.tvretro.unixretro.videoretro.video.binariesretro.watersportsretro.wwwretro.www.flashdiylt.rkm.news.announcelt.rkm.news.newuser
Q: PostgreSQL ir backslashErnikas2010-08-16 17:24
+VS2010 solution openSaulius2010-08-16 15:02
+Regex validationBamba2010-08-12 17:03
+oracle recursive triggerledasl2010-08-12 14:58
-MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 14:29
Re: MSSQL2000 DATETIME --> DATErl2010-08-12 16:05
Re: MSSQL2000 DATETIME --> DATE2x502010-08-12 15:05
Re: MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 15:20
Re: MSSQL2000 DATETIME --> DATE2x502010-08-12 15:23
Re: MSSQL2000 DATETIME --> DATEDream-Colored Bunny2010-08-12 15:31
Re: MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 15:35
Re: MSSQL2000 DATETIME --> DATE2x502010-08-12 15:46
Performance test results (kb)@Jornada Del Muerto2010-08-12 16:27
Re: Performance test results (kb)Laimis2010-08-12 16:55
Re: Performance test results (kb)Jornada Del Muerto2010-08-12 17:01
Re: Performance test results (kb)zZz2010-08-13 10:27
Re: Performance test results (kb)Jornada Del Muerto2010-08-13 10:43
Re: Performance test results (kb)Laimis2010-08-13 20:34
Re: Performance test results (kb)Jornada Del Muerto2010-08-14 10:45
Re: Performance test results (kb)@Jornada Del Muerto2010-08-12 16:32
Re: MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 14:31
+ASP.net kokie kontrolaiSaulius2010-08-11 13:33
+MSSQL rodo ne visus dependenciesJornada Del Muerto2010-08-08 13:16
+Paslepti swf, jei nera instaliuotas flash?System2010-08-07 13:33
+Win7 x64 trablas su MySQL instaliavimuVinetu2010-08-06 18:55
+Q: Visual Studio 2010 performancezZz2010-08-05 14:02
Q: Emailų nuskaitymasGiedrius 2.52010-08-05 09:23
+JavaScript automatinis testavimasBraunikas <labai @ bais . us>2010-08-04 19:03
ASAP ClickOnce ir Signed assemblyJornada Del Muerto2010-08-02 17:32
+ASP.net ajax ir nepkraunamas GridviewklevoLapas2010-07-22 15:15
+Kas galetu pagelbeti su kurimutom2010-07-19 20:13
+formos elementų listasS.2010-07-19 11:42
+100 formųS.2010-07-19 11:32
+Q: SOAP envelopeMauzer2010-07-16 09:31
+e-bankaievaldas2010-07-15 22:00
+Pakonsultuokit apie MySQLNicMC2010-07-15 15:28
+DiapazonaiJornada Del Muerto2010-07-15 13:26
SAp'o reference manual gal pas ka yra?Sail2010-07-15 08:28
+radau skelbimaledasl2010-07-14 18:49
+.net 2.00 asynchronous webservices accessJornada Del Muerto2010-07-13 14:24
+(My)SQL online training?VA2010-07-12 15:57
+delphi ar c++AMB2010-07-09 15:37
+maza apklausfakeID2010-07-08 12:54
+WEB reloudinimasIF2010-06-30 13:44
+.NET tipai + UI + MSSQL moneyJornada Del Muerto2010-06-30 13:27
+req: sarasas firmu dirbanciu su .netfakeID2010-06-29 13:33
+Zodziu sakymasValdas2010-06-29 08:01
+Pataisa Delfi 7 projektukuikrx2010-06-28 23:22
+Access 2007 VBA klausimukasGedikas2010-06-26 13:04
+C++ compilerlover2010-06-24 11:37
Emacs, grep, koduotėsLaimis2010-06-20 18:16
+Q: Excel hyperlink convert to textMinVodai2010-06-17 08:22
+Q: slaptas chatinimasErnikas2010-06-15 11:39
+mssql ilgiaiS.2010-06-14 13:54
+Pakomentuokit reikalavima uzsakovobooraz2010-06-11 14:22
MSSQL Funkcija i OpenQuery?bala nemate2010-06-10 11:15
+Kaip vadinasiS.2010-06-09 10:47
+SMS rate'asflegmatoid2010-06-09 10:36
+excelio (arba OpenOffice calc) klausimasnagi kagi2010-06-07 23:51
+REQ: Java ebookVaidaskz2010-06-04 12:59