On Thursday, November 06, 2003 1:53 PM Ariefn wrote:

>
> Terus, saya coba declare UDF tsb pada file database yg lain (.gdb).
> Dan run query, hasilnya lain lagi, yaitu : 11/22/29 1:08:00 AM   (Apapun
'date' nya)
>

loh, saya coba ndak ada masalah... coba liat kode berikut deh.

select FixedDateTime('now') from rdb$database

FIXEDDATETIME: 06/11/2003 9:54:00

(FB-1.03.972)
---------------
function FixedDateTime(const ib_date: PISC_QUAD): PISC_QUAD; cdecl; export;
var
  tm_date: tm;
begin
  isc_decode_date(ib_date, @tm_date);
  tm_date.tm_sec := 0;
  isc_encode_date(@tm_date, ib_date);
  Result := ib_date;
end;

exports
    FixedDateTime;

/*******************************/
declare external function fixeddatetime
  timestamp
  returns timestamp free_it
  entry_point 'FixedDateTime' module_name 'jzftslib.dll';

Salam,

-Jaimy
--
``Always listen to experts.  They'll tell you what can't be done, and why.
Then do it.''
      -- Lazarus Long


------------------------ 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/ 


Kirim email ke