Buat dan Panggi Store Procedure di Mysql

Step Stepnya : Buat Store procedure di mysql Test panggil store tersebut Test query database apakah proces ke 2 jalan Buat Store procedure di mysql — DROP PROCEDURE DeleteAuditSheetData; DELIMITER $$ CREATE PROCEDURE DeleteAuditSheetData (     IN p_AuditSheetMonth SMALLINT,     IN p_AuditSheetYear SMALLINT ) BEGIN     — Mulai transaksi     START […]

The TimeZone problemOfficial Content

The TimeZone problem Users of Web or Smart Device applications are frequently located in different time zones, both among themselves and in relation to the application server. In this context, data of DateTime data type can be entered and viewed in different time zones. Failure to take this into account may lead to confusion when interpreting DateTime […]

TimeZone Support – DateTime handlingOfficial Content

If TimeZone Support is enabled, DateTime fields entered by the user, DateTime constants and all operations performed on DateTime fields are made in the CTZ. A conversion to the value indicated in the DateTime storage timezone property (and to read inversely from that value) is performed only to save it in the database. Example An event application such as EventDay (X […]

ToUniversalTime methodOfficial Content

Converts a DateTime value to Coordinated Universal Time (UTC), assuming that the DateTime to convert to is the server’s time zone. DateTime-expression.ToUniversalTime() DateTime-expression Is a DateTime expression to which the method applied converts to Coordinated Universal Time (UTC) Type returned: DateTime Scope Data Types:  DateTime Generators: .NET, .NET Framework, Java, Ruby (up to GeneXus X Evolution 3) Samples &MeetingInUTC = &MeetingDateTime.ToUniversalTime() &MeetingInUTC = &MeetingDateTime.AddDays(5).ToUniversalTime()

How to change the port of Tomcat from 8080 to 80?

How to change the port of Tomcat from 8080 to 80? I want to execute my web app as http://localhost. 1) Go to conf folder in tomcat installation directory e.g. C:\Tomcat 6.0\conf\ 2) Edit following tag in server.xml file <Connector connectionTimeout=”20000″ port=”8080″ protocol=”HTTP/1.1″ redirectPort=”8443″/> 3) Change the port=8080 value to port=80 4) Save file. 5) Stop your Tomcat and restart it. On Ubuntu […]

Cara Cek Versi MySQL: Mengidentifikasi Versi Database MySQL yang Digunakan

1. Menggunakan Perintah SQL “SELECT VERSION();” Salah satu cara termudah untuk memeriksa versi MySQL adalah melalui perintah SQL SELECT VERSION();. Perintah ini mengembalikan nomor versi MySQL yang digunakan oleh server basis data. Berikut adalah langkah-langkahnya: Buka terminal atau klien MySQL, dan pastikan Anda terhubung ke server yang sesuai. Ketik perintah berikut: SELECT VERSION();

What are the possible ways to determine the deployed SQL Server version?

Method 1: Connect to the instance of SQL Server, and then run the following query: Select @@version An example of the output of this query is as follows: Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

Cara Aktivasi Windows 10 Pro Tanpa Software (100%% Permanen)

Seperti yang kita ketahui bahwa Windows 10 merupakan sistem operasi desktop yang paling populer saat ini, bahkan sudah melangkahi pendahulunya yakni Windows 7 dan 8. Bahkan popularitas Windows 10 sudah menggait 50% pengguna PC di Amerika Serikat, sisanya diisi dengan sistem operasi lain seperti Linux, MacOS dan lain sebagainya. Windows 10 merupakan sistem operasi berbayar dimana anda […]