Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

CURRENT_TIME format in esql

What is the default format of the function CURRENT_TIME in esql and how do we change it as per our requirements(24 hr or 12 hr formats)

like image 493
Lee Avatar asked Feb 02 '13 11:02

Lee


1 Answers

DECLARE castTime TIME;
SET castTime = CAST (timeValue AS TIME FORMAT timePattern)

where pattern can be

enter image description here

like image 69
Richie Avatar answered Jan 01 '23 12:01

Richie



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!