Kalau gak mau repot bikin view atau table ya selectnya gini aja :
select getdate() into :date_var from dummy;
Tuesday, January 16, 2007, 11:41:06 AM, you wrote:
> 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.
>>
>>
>>
>>
>
--
Best regards,
abraar mailto:[EMAIL PROTECTED]
-----------------------------------------------
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/
