Tarih ve Saat Fonksiyonları

[kbakcaoglu]

1.SELECT now();

2.SELECT Day(#17/05/2012#);

3.SELECT Month (#17/05/2012#);

4.SELECT Year(#17/05/2012#);

5.SELECT DateAdd("yyyy",3,#11/22/2009#);

6.SELECT DateAdd("d",70,#11/22/2009#);

7.SELECT DateAdd("m",80,#11/22/2009#);

8.SELECT DateDiff(‘d’,#17/05/1996#,now());

9.SELECT DateDiff("m",#17/05/1996#,now());

10.SELECT DateDiff("yyyy",#17/05/1996#,now());

11.SELECT DatePart("d", "01/04/2012");

12.SELECT DatePart("m", "01/04/2012");

13.SELECT DatePart("yyyy", "01/04/2012");


Açıklamaları

1.Bulunduğumuz anı saniye,dakika,saat,gün,ay,yıl şeklinde hücreye çıktı verir.

2.## içinde yazdığınız tarihin sadece gününün çıktısını verir.

3.## içinde yazdığınız tarihin sadece ayının çıktısını verir.

4.## içinde yazdığınız tarihin sadece yılının çıktısını verir.

5.## içinde yazdığınız tarihe ,, arasında yazdığımız miktar kadar yıl ekler.

6.## içinde yazdığınız tarihe ,, arasında yazdığımız miktar kadar gün ekler.

7.## içinde yazdığınız tarihe ,, arasında yazdığımız miktar kadar ay ekler.

8.## içinde yazdığınız tarihle bulunduğumuz tarih arasındaki günü hesaplar.

9.## içinde yazdığınız tarihle bulunduğumuz tarih arasındaki ayı hesaplar.

10.## içinde yazdığınız tarihle bulunduğumuz tarih arasındaki yılı hesaplar.

11."" içinde yazdığınız tarihin sadece gününün çıktısını verir.

12."" içinde yazdığınız tarihin sadece ayının çıktısını verir.

13."" içinde yazdığınız tarihin sadece yılının çıktısını verir.

[FrankJScott]

Please try Google before asking about Cool Product Info 70d05cf

[eorzopomavs]

Hard ulceration; descends diclegis for sale cheap viagra flomax cost generic lasix from canada phenytoin bro-zedex syrup generic amigrenex at walmart amigrenex 25mg alipid coupons cialis strips amlipin 10mg buy online cheap generic tamoxifen lowest afinitor prices womenra kaufen in berlin natdac price topamax albenil aknemycin.com lowest price gemfibrozil cartia generic tazorac at walmart canadian parmacy fildena 150 lamisil cream non generic buy generic sulfamethoxazole zomig without pres lowest plan b one-step prices buy tadapox no perscription buy generic ziagen canada online ziagen without dr prescription victoza generic actilax glipizide generic humerus, non-occlusive <a href="https://cassandraplummer.com/diclegis/">diclegis</a> <a href="https://center4family.com/cheap-viagra/">viagra online uk</a> <a href="https://weddingadviceuk.com/item/flomax/">flomax cost</a> <a href="https://cafeorestaurant.com/drugs/lasix/">fast lasix without a prescription</a> <a href="https://breathejphotography.com/drug/ph ... ">purchase phenytoin without a prescription</a> <a href="https://mrindiagrocers.com/bro-zedex-syrup/">generic bro-zedex syrup uk</a> <a href="https://cafeorestaurant.com/item/amigrenex/">amigrenex pills</a> <a href="https://cafeorestaurant.com/product/alipid/">alipid</a> <a href="https://endmedicaldebt.com/item/cialis-strips/">cialis strips without prescription</a> <a href="https://greaterparsippanyrewards.com/amlipin/">buy amlipin no prescription</a> <a href="https://cassandraplummer.com/tamoxifen/">legal tamoxifen online</a> <a href="https://cassandraplummer.com/drugs/afinitor/">afinitor without a prescription</a> <a href="https://ifcuriousthenlearn.com/womenra/">100 womenra on line</a> <a href="https://productreviewtheme.org/natdac/">generic natdac lowest price</a> <a href="https://theprettyguineapig.com/topamax/">topamax online</a> <a href="https://greaterparsippanyrewards.com/albenil/">albenil 400mg</a> <a href="https://greaterparsippanyrewards.com/ak ... >aknemycin prices</a> <a href="https://bhtla.com/gemfibrozil/">buy gemfibrozil w not prescription</a> <a href="https://endmedicaldebt.com/cartia/">buy cartia online cheap</a> <a href="https://productreviewtheme.org/tazorac/">tazorac capsules for sale</a> <a href="https://mrindiagrocers.com/purchase-fil ... fildena</a> <a href="https://mrindiagrocers.com/item/lamisil-cream/">lamisil cream without a doctors prescription</a> <a href="https://breathejphotography.com/sulfame ... oxazole</a> <a href="https://bhtla.com/zomig/">cheapest zomig</a> <a href="https://productreviewtheme.org/plan-b-one-step/">plan b one-step brand</a> <a href="https://eastmojave.net/item/tadapox/">tadapox</a> <a href="https://cubscoutpack152.org/ziagen/">ziagen le moin cher</a> <a href="https://leadsforweed.com/product/victoz ... glutide</a> <a href="https://greaterparsippanyrewards.com/ac ... actilax</a> <a href="https://computer-filerecovery.net/item/ ... ">purchase glipizide online</a> collate circumflex stem; https://cassandraplummer.com/diclegis/ https://center4family.com/cheap-viagra/ https://weddingadviceuk.com/item/flomax/ https://cafeorestaurant.com/drugs/lasix/ https://breathejphotography.com/drug/phenytoin/ https://mrindiagrocers.com/bro-zedex-syrup/ https://cafeorestaurant.com/item/amigrenex/ https://cafeorestaurant.com/product/alipid/ https://endmedicaldebt.com/item/cialis-strips/ https://greaterparsippanyrewards.com/amlipin/ https://cassandraplummer.com/tamoxifen/ https://cassandraplummer.com/drugs/afinitor/ https://ifcuriousthenlearn.com/womenra/ https://productreviewtheme.org/natdac/ https://theprettyguineapig.com/topamax/ https://greaterparsippanyrewards.com/albenil/ https://greaterparsippanyrewards.com/aknemycin/ https://bhtla.com/gemfibrozil/ https://endmedicaldebt.com/cartia/ cartia overnight https://productreviewtheme.org/tazorac/ https://mrindiagrocers.com/purchase-fildena/ https://mrindiagrocers.com/item/lamisil-cream/ https://breathejphotography.com/sulfamethoxazole/ https://bhtla.com/zomig/ https://productreviewtheme.org/plan-b-one-step/ https://eastmojave.net/item/tadapox/ https://cubscoutpack152.org/ziagen/ https://leadsforweed.com/product/victoza/ https://greaterparsippanyrewards.com/actilax/ https://computer-filerecovery.net/item/glipizide/ triggered glomerulus.