cuman ingin nambahkan untuk database ORACLE, SQLnya adalah
SELECT TO_CHAR(SYSDATE, ''MM/DD/YYYY'') FROM DUAL
function getServerDate:string;
begin
qry.SQL.Clear;
qry.SQL.Add('SELECT TO_CHAR(SYSDATE, ''MM/DD/YYYY'') FROM DUAL');
qry.Open;
result:=qry.fields[0].AsString;
end;
TathitSA
>>> [EMAIL PROTECTED] 10/08/03 06:33PM >>>
> delhpier....
> saya baru dev. pgrogram client server...
> tapi saya bingung cara ngambil time dari server...
Jika memakai application server, maka buat fungsi di app server seperti
function : getServerTime : Time;
begin
result := now;
end
dan seperti biasa, panggil fungsi tsb di app client;
Jika diambil dari RDBMS maka gunakan fungsi internal suatu rdbms
Dan jika memakai Firebird/Interbase sebagai RDBMS
Select current_time from rdb$database
RDBMS yg lain seperti Oracle, SQL Server juga mempunyai fungsi seperti itu,
coba di explorasi dahulu
HTH
Bayu
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
