Arsip: transfer waktu ke SQL

more 17 years ago
coacoac
Para master delphi yang baik hati...
gimana ya caranya ngambil waktu sekarang trus dikirimkan ke SQL, misalnya gini..se2orang pinjam buku pada pada (waktu:= tgl 18 juli 2007, jam 13:35). gmana ya caranya agar waktu tersebut dapat dikirimkan ke SQL dg perintah yang ada di delphi..he...plizzzzz :D

more 17 years ago
DelphiExpert
macro/constants bawaan dari DB engine sudah ada, misal CURRENT_TIMESTAMP dll. tergantung DB engine yg dikau pakai.
utk passing dari delphi cukup pakai params, ambil current date-time value pakai fungsi Now(). contoh:
XXXSQL1.SQL.Text:= 'INSERT INTO TBX VALUES (:DateTime ...)';
XXXSQL1.Params[0].AsDateTime:= Now;
XXXSQL1.Execute;

more 17 years ago
coacoac
oya sory ketinggalan, sebenarnya saya pake' SQLConnection+SQLDaraSet, klo pake' kedua komponen tsb, gmana ya cara mengambil current date-time tsb.

more 17 years ago
mas_kofa
@DE aku pernah pake itu........di mysql....................................
aku bikin fungsi sendiri untuk mengkonversi format tanggal yang sesuai......
tapi pake cara @DE..........perlu aku coba juga......

more 17 years ago
DelphiExpert
passing pakai native query, maksudnya generate query syntax lengkap dengan valuenya...
DBEngine/DB Provider kamu apa?
SQL:= Format('INSERT INTO TBX VALUES (%s)', [FormatDateTime(DATE_TIME_FORMAT_DB_KAMU, Now)]);
@mas_kofa: benar, format date-time harus sesuai dengan format yg dikenali oleh DB Engine... masing2 tidak sama, Access, FireBird, MySQL dll. punya format sendiri2...
more 17 years ago
coacoac
iya saya pakek MySQL Version 4.0.1 dan format DateTimenya (mm/dd/yyyy), mb kayak gitu...saya pengen ngambil timedate tersebut saya pengen langsung kirim ke tabel yang ada di MySQLq.

more 17 years ago
DelphiExpert
@coacoac: aduh mas coacoac... pertanyaan anda sudah terjawab dari tadi kooq...
ini rekan2 yg ngga' mudheng atau sebaliknya toh? :mrgreen:
more ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- Syntax RIGHT, LEFT dan MID pada delphi 7
by ari_volker in Tip n Trik Pemrograman more 17 years ago - Modular Programming di Delphi
by bagussb in Tip n Trik Pemrograman more 17 years ago - Buat Master Detail???
by mrsatan_26 in Reporting more 15 years ago - Get TDBEdit Value Menggunakan LookUp Grid
by lukersgn in Reporting more 12 years ago - help..... USB to SERIAL mengunakan ic FT232 BL :((
by tsalits in Network, Files, I/O & System more 12 years ago - Satu listing program bisa di panggil di beberapa form
by musespratama in Delphi.NET more 13 years ago - HELP
by purwa in Hal umum tentang Pascal Indonesia more 17 years ago - Cara Membuat Tabel yang Data master tidak bisa dihapus
by onsir in MySQL more 17 years ago - banyak bertanya ?????????
by brodien in Enginering more 18 years ago - Menampilkan image captcha di Twebbrowser
by kusqus in Web Programming more 15 years ago