Sebuah lab computer dipasang 10 kVA, sedangkan setiap unit computer membutuhkan daya 50 watt, maka computer yang dapat dipasang pada lab tersebut sebanyak. Mengambil data dengan type data text seperti data berita b. Mengembalikan tanggal c. Mengambil data sebagian karakter dari variabel tanggal d. Mengambil data sebagian karakter dari variabel tanggal kemudian disusun ulang e. Mengambil karakter nomor 0,2,3,4, dan 6 34.
Contact Support about this user's behaviour.
Understand even more about reporting mistreatment
Statement mistreatmentView GitHub ProfileLook atconvert-generaldate-to-iddate.php// $tgl must be formatted to YYYY-mm-dd |
function tglengtoind($tgl) |
$tglind=substr($tgl,8,2).'-'.substr($tgl,5,2).'-'.substr($tgl,0,4); |
return $tglind; |
// This function will convert from indonesian day format (dd-mm-yyyy) to common format (yyyy-mm-dd) |
function tglindtoeng($tgl) |
$tgleng=substr($tgl,6,4).'-'.substr($tgl,3,2).'-'.substr($tgl,0,2); |
return $tgleng; |
function rupiah($nilai, $pecahan = 0) |
return numberformat($nilai, $pecahan, ',', '.'); |
// $tgl must possess general's day format (YYYY-mm-dd) |
function tglindo($tgl) |
$tanggal=substr($tgl,8,2); |
$bulan=getBulan(substr($tgl,5,2)); |
$tahun=substr($tgl,0,4); |
return $tanggal.' '.$bulan.' '.$tahun; |
This Oracle guide explains how to make use of the 0racle/PLSQLSUBSTR function with format and illustrations.
Explanation
Thé 0racle/PLSQL SUBSTR features enables you to draw out a substring from a line.
Format
The syntax for thé SUBSTR functión in 0racle/PLSQL is definitely:
Parameters or Disputes
- chain
- The resource line.
- startpósition
- Thé beginning position for extraction. The very first position in the chain is continually 1.
- duration
- Optional. It is the number of character types to draw out. If this parameter is certainly omitted, the SUBSTR functión will return thé whole string.
Profits
The SUBSTR function returns a line worth.
Ifdurationis a adverse number, then the SUBSTR functión will return á NULL value.
Ifdurationis a adverse number, then the SUBSTR functión will return á NULL value.
Note
- lfstartpositionis usually a beneficial number, after that the SUBSTR function begins from the starting of the string.
- lfstartpositionis definitely a bad number, after that the SUBSTR function starts from the finish of the thread and counts backwards.
- Notice also the REGEXPSUBSTR functión.
AppIies Tó
Thé SUBSTR function cán become used in the pursuing versions of 0racle/PLSQL:
Example
Allow's appear at some 0racle SUBSTR function examples and discover how to use the SUBSTR functión in 0racle/PLSQL.
Fór illustration: