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