Ass. Wr. Wb.
Mas Aksan,

        Thank;s Jlan mas

Wass.Wr.Wb.

Riyan                           
mailto:[EMAIL PROTECTED]
______________________ Reply Separator ______________________

> -----Original Message-----
> From   : aksan kurdin, [EMAIL PROTECTED]
> Sent   : Thursday, January 3, 2008, 1:20:26 PM, 
> To     : [email protected]
> Cc     : 
> Subject: [belajar-access] Format Tahun dari field type Datetime di SQL Server
 
> select tanggal, year(tanggal) as tahun from tabelanu

> aksan kurdin


> On 1/2/08, Riyan <[EMAIL PROTECTED]> wrote:
>>
>>   Ass. Wr. Wb.
>> [email protected] <belajar-access%40yahoogroups.com>,
>>
>> Kalo di Access tinggal buat field baru
>> diquery desain kemudian disi dengan
>> Tahun:format([tgl_entry],"yyyy")
>>
>> Kalau di SQL Server 2000 gimana ya rekan2 suhu access.
>>
>> Terima kasih sebelumnya atas jawabannya
>>
>> Wass.Wr.Wb.
>>
>> Riyan
>> mailto:[EMAIL PROTECTED] <riyan%40spij.co.id>
>>
>> 
>>



Kirim email ke