[linux-programlama] Re: MySQL'de tarih aral___na göre kay_t seçme

• Previous message: Özgür ÖZASLAN: "[linux-programlama] Re: [linux-programlama] Re: MySQL'de tarih aral_Q=5Fna_g=F6re_kay=5Ft_se=E7me?="

e=F0er bu sorgulamay=FD php de yapmaya kalkarsan diziye
atman falan gerekir buda sistemi yorar hatta veri say=FDs=FD
fazla ise kilitler
ikinci bi sorun ise tarih tiplerindeki uyu=FEmazl=FDkta olur genel
olarak php nin ve sql in verdi=F0i tarih tipleri birbirine uymaz
bu y=FCzden senin bunlar=FD birbirine uydurman gerekir
sonu=E7 olarak burada sql en mant=FDkl=FDs=FD g=F6r=FCn=FCyor

Melih Sakarya
Software Engineer

INFOTECH Information Technologies
Email: msakarya@infotech.com.tr
Web: www.infotech.com.tr
Phone:+90 (212) 259 21 99 (129)
Fax: +90 (212) 259 30 32
Address: Ayazma Deresi Cad. Aksit Plaza no:12
               Fulya Besiktas \ Istanbul

                                                                       =
                                                               =20
                    "=D6zg=FCr =D6ZASLAN" =
                                                                     =20
                    <listeler@ins.itu.edu.tr> To: <l=
inux-programlama@liste.linux.org.tr> =20
                    Sent by: cc: =
                                                               =20
                    linux-programlama-bounce@liste.li Subject: =
   [linux-programlama] Re: [linux-programlama] Re: MySQL'de =20
                    nux.org.tr tarih aral=
___na g=F6re kay_t se=E7me =20
                                                                       =
                                                               =20
                                                                       =
                                                               =20
                    02.06.2003 08:44 =
                                                               =20
                    Please respond to =
                                                               =20
                    linux-programlama =
                                                               =20
                                                                       =
                                                               =20
                                                                       =
                                                               =20

Merhabalar,
Te=FEekk=FCrler.

=D6zg=FCr =D6ZASLAN
http://ozaslan.ifbim.itu.edu.tr

----- Original Message -----
From: "Doruk Fisek" <dfisek@fisek.com.tr>
To: <linux-programlama@liste.linux.org.tr>
Sent: Sunday, June 01, 2003 9:30 PM
Subject: [linux-programlama] Re: MySQL'de tarih aral___na g=F6re kay_t =
se=E7me

Merhaba,

Sun, 1 Jun 2003 18:23:49 +0300 tarihinde "=D6zg=FCr =D6ZASLAN"
<listeler@ins.itu.edu.tr> soyle yazdi:

OO> Tarih (date) format=FDnda tuttu=F0um verilere ait bir aral=FD=F0=FD=
 PHP'de nas=FDl
OO> sorgulayabilirim? MySQL'de bu m=FCmk=FCn m=FC yoksa PHP kod ile tar=
ih
OO> de=F0erini say=FDsal bir de=F0ere =E7evirip, aral=FDk m=FD aratmal=FD=
y=FDm?
tarih formatini mysql yil-ay-gun olarak tutar. bu sekilde zaten sanki r=
akam
karsilastirir gibi karsilastirabilirsiniz. ornegin,

SELECT * FROM tablo WHERE tarih BETWEEN "2003-01-01" AND "2003-06-01"

SQL diline giris ile ilgili guzel bir anlatim,
http://riki-lb1.vet.ohio-state.edu/mqlin/computec/tutorials/SQLTutorial=
.htm

                               Doruk

--
FISEK ENSTITUSU - http://www.fisek.com.tr
Ankara   : (0312) 3857026 - 4197811
Istanbul : (0216) 4284693 - 4284694
=

• Previous message: Özgür ÖZASLAN: "[linux-programlama] Re: [linux-programlama] Re: MySQL'de tarih aral_Q=5Fna_g=F6re_kay=5Ft_se=E7me?="