Buat View di SQL Server yg isinya
getdate() seperti yg dijelaskan bpk sofyan
terus buat function global yang mengambil nilai view tsb
Contoh View :
CREATE VIEW dbo.vw_serverdate
AS
SELECT GETDATE() AS SERVERDATE, { fn HOUR(GETDATE()) } AS SERVERTIME
Contoh Global Function :
global function datetime f_serverdate ();datetime ldt_today
SELECT vw_serverdate.SERVERDATE
INTO :ldt_today
FROM vw_serverdate ;
return ldt_today
selamat mencoba
On 11/01/07, Sofyan Bahri <[EMAIL PROTECTED]> wrote:
> pakai ini saja pak
>
> datetime ldt_today
>
> select getdate() into :ldt_today from table_name ;
>
>
>
> salam
>
>
> Sofyan Bahri
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of
> robbi robbi
> Sent: Thursday, January 11, 2007 3:48 PM
> To: [email protected]
> Subject: [indopb] Menampilkan Tgl Server
>
>
>
> Dear all
>
> Saya membuat aplikasi dengan 1 Server Sybase dan 3 Client
> (Cleint-Server )
>
> Pada Aplikasi kami di masing-masing akan memunculkan tgl system dari
> Server (Tgl pada komputer Server).
>
> Bagaimana cara nya / command nya ?
>
> Terima kasih
>
>
>
>
>
> ----------------------------------------------------------------------------
> --
> Everyone is raving about the all-new Yahoo! Mail beta.
>
>
>
>
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/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/
