Re: [ITCENTER] Re: Query Oracle aneh (bugs atau apa ya ?)

[Marthen LT]

Hi Harry,

ya jelas beda, hasil dari parser to_char adalah string (varchar).
di string data type, '06/11/2007' tidak sama dengan '6/11/2007'.

coba kalau pembandingnya anda gunakan datetime, misal  select.where 
date_time between TIMESTAMP'2007-10-01 00:00:00' and TIMESTAMP'2007-11-06 
00:00:00'  (atau TIMESTAMP'2007-11-6 00:00:00') pasti akan memberikan hasil 
yang sama.
atau bisa gunakan TO_DATE().

silahkan googling untuk sample querynya.
Hope this may help.


-Marthen

--- In [EMAIL PROTECTED] s.com, Harry Christian [EMAIL PROTECTED]  wrote:

 Kemarin saya sudah berkeluh kesah di blog saya

 http://harry- christian. blogspot. com/2007/ 11/bugs-in- oracle-query. html

 saya paste aja ya

 

 I want to query a data with date condition. Guess what ? This

similiar query

 give a different result.

 

 1st query give the exact result that i wanted.

 SELECT * FROM my_table

 WHERE TO_CHAR(date_ time, 'DD/MM/' ) BETWEEN '01/10/2007' and

'6/11/2007'

 

 2nd query result nothing

 SELECT * FROM my_table

 WHERE TO_CHAR(date_ time, 'DD/MM/' ) BETWEEN '01/10/2007' and

'06/11/2007'




  




 
















__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 

 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [ITCENTER] Nyamannya berinternet di singapura

[Marthen LT]

Income Tax Singapore 6% + SINDA/CDAC/MOSQ + CPF (klo udah PR dan akan bertambah 
klo setiap tahun)

sorry, tolong koreksi klo salah
:)

rgds,
marthen

- Original Message 
From: The_Eye_In_The_Sky [EMAIL PROTECTED]
To: ITCENTER@yahoogroups.com
Sent: Wednesday, January 10, 2007 8:34:03 AM
Subject: Re: [ITCENTER] Nyamannya berinternet di singapura

Thio Agustinus wrote:
 Di singapura bisa dapat murah dan cepat, ya karena berani bayar mahal,
 termasuk pajak-pajaknya yang cukup memberatkan. Tapi konsekuensinya uang
 pajak itu 'dikembalikan' kepada masyarakat, sebagai kenyamanan dalam
 beraktifitas.
FYI, kerja di Indonesia, PPh saya 24%. Kerja di Singapore, Income Tax 
saya 6%
Belanja di Indonesia, PPN saya 10%, belanja di Singapore GST saya 5%

=D
Send instant messages to your online friends http://asia. messenger. yahoo.com 



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]



-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [ITCENTER] Re: Nyamannya berinternet di singapura

[Marthen LT]

dising foreigner yang boleh dibilang banyak adalah india  malay.
indo justru banyak sebagai maid (exclude me :P).
yup, jadi gak bener 3/4 populasinya adalah indo
:)

- Original Message 
From: The_Eye_In_The_Sky [EMAIL PROTECTED]
To: ITCENTER@yahoogroups.com
Sent: Wednesday, January 10, 2007 8:23:44 AM
Subject: Re: [ITCENTER] Re: Nyamannya berinternet di singapura

Mikail wrote:
 Rekan-rekan jangan lupa 3/4 dari penduduk di Singapore banyak orang-
 orang dari warga Kita tentunya mereka pada Berduit :-)
Statistik anda ngawur. Foreigner di Singapore cuman 20%. Dan dari 20% 
itu Indonesian bukan yg terbesar.
Dan dari sebagian besar Indonesian di Singapore, kebanyakan ber-profesi 
non technical alias pembantu rumah tangga.

Salah satu TKI di Singapore
Send instant messages to your online friends http://asia. messenger. yahoo.com 



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]



-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [ITCENTER] numpang nanya nich

[Marthen LT]

Hi Paul, wah jarang ada yang punya cita2 luhur kayak kamu.
hebat all the best buat kamu..
Gbu.

 
Rgds,
Marthen
Pesan Global
http://www.pesanglobal.com



- Original Message 
From: paul dermawan [EMAIL PROTECTED]
To: ITCENTER@yahoogroups.com
Sent: Sunday, October 29, 2006 4:48:06 PM
Subject: [ITCENTER] numpang nanya nich

Saya ingin mengembangkan dunia IT di papua pada saat ini karna pada saat ini 
tempat kursus yang ada hanya berupa office saja jadi saya ingin membuat 
training web, admin, teknisi dan lain sebagainya kira2 ada yang punya 
pengalaman di bidang ini untuk bagaimana mengenalkan produk ini kemasyarakat 
karna yang selama ini ada hanya office melulu lho

 - - ---
Low, Low, Low Rates! Check out Yahoo! Messenger's cheap PC-to-Phone call rates.

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]




-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [ITCENTER] -Butuh Penjelasan- Kenapa harus ada UML?

[Marthen LT \(Pesan Global\)]

alo Jeni,
sebenarnya UML seperti modelmaker, rational rose, etc
sendiri diciptakan untuk membuat flow kerja (engine
process) lebih efisien, tapi balik lagi apakah kita
punya cukup waktu untuk mapping business process ke
dalam uml ini??... saya sendiri masih sering
menggunakan cara lama yang sekedar mencoret2 kertas
atau pas lagi rajin menggambarnya dalam dfd/erd
untuk project2 yang sangat tight development time-nhya
atau project2 yang simple.

contoh lainnya adalah SDLC. kalau mau jujur ada
kalanya kita tidak menggunakan sdlc secara berurutan
yaitu mulai dari analisa, coding, debugging, maintain
s/d dokumentasi
saya pribadi sering menemukan programmer yang langsung
masuk ke fase coding, baru kemudian mulai analisa...
ini bisa2 saja terjadi karena keterbatasan SDM
misalnya, tight schedule, etc.

so, saya kembalikan lagi kepada anda. mudah2an
bermanfaat.



--- Jeni Sudarwati [EMAIL PROTECTED] wrote:

 Jika psikologi sampai sekarang masih sulit
 mengukuhkan posisinya yang absurd, dan pencarian
 orang Sastra yang dengan pola pikir seni sehingga
 sulit menemukan kebenaran. Ternyata di dunia teknik
 informatika juga tidak kalah menariknya...
 

--message has been cut--

Rgds,
Marthen
Pesan Global
http://www.pesanglobal.com

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$

[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id 

 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [ITCENTER] koneksi SQL SERVER Express 2005 ke delphi7

[Marthen LT \(Pesan Global\)]

bisa pakai ado/odbc.
untuk ado coba cari komponen TADOConnection
untuk odbc cari komponen TDatabase

sql express, ehm blom coba seeh seperti msde?? tapi
untuk 2 koneksi di atas pasti ada. 

met ngoding


--- f4tahillah [EMAIL PROTECTED] wrote:

 dear temen-temen,
 langsung aja,
 
 kira2 materi apa yang harus saya pelajari untuk
 mengkoneksikan DB yang
 saya buat via SQL Server 2005 Express Ed. ke delphi
 
 kalo ada yang yang mau kasi detilnya, saya sangat
 berterima kasih.
 
 but, materi yang harus saya pelajari aja juga sangat
 membantu
 
 thx bro
 
 
 
 
 
 
 


Rgds,
Marthen
Pesan Global
http://www.pesanglobal.com

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 




-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$

[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id 

 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [ITCENTER] Koneksi SQL Server 2000 pada Java -- ERROR: no suitable driver

[Marthen LT \(Pesan Global\)]

anda pakai sql server versi apa?
jdk v1.4.2 ideal dipakai di v7/2000. 

Pastikan jdbc-nya terinstall dengan baik.
jika tidak bisa juga gunakan di variable url port
server ms.sql-nya, ex 1433 (default).

saran saya pastikan dulu jdbcnya jalan, jangan
terburu2 update ke sp3. 

sukses!


--- Eka Putri [EMAIL PROTECTED] wrote:

 Versi java yang dipakai J2SDK1.4.2
 Driver JDBC yang dipakai Service Pack 3
 
 Source code yang dibuat:
 
 import java.sql.*;
 public class Test2 {
 public static void main(String[] args) {
 
 try {
 // Get connection
 DriverManager.registerDriver(new 
 com.microsoft.jdbc.sqlserver.SQLServerDriver());
 String url=jdbc:microsoft:sqlserver://nama 
 komputer;DatabaseName=nama database;
 Connection conn=DriverManager.getConnection
 (url,user,password);
 Statement stmt=conn.createStatement();
 DatabaseMetaData meta = conn.getMetaData();
 if (conn != null) {
 System.out.println();
 System.out.println(Successfully connected);
 System.out.println();
 // Meta data
 
 System.out.println(\nDriver Information);
 System.out.println(Driver Name:  +
 meta.getDriverName());
 System.out.println(Driver Version:  +
 meta.getDriverVersion());
 System.out.println(\nDatabase Information );
 System.out.println(Database Name:  +
 meta.getDatabaseProductName
 ());
 System.out.println(Database Version:  + 
 meta.getDatabaseProductVersion());
 }
 } catch(SQLException se) {
 System.out.println(ERROR:  + 
 se.getMessage()); }
 }
 
 }
 
 Trus ternyata pesan errornya:
 ERROR: No suitable driver
 
 
 Ada yang bisa ngasih solusinya gak?
 
 Sebelumnya makasih banyak
 
 
 
 
 
 
 
 
 


Rgds,
Marthen
Pesan Global
http://www.pesanglobal.com

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$

[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id 

 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/