CURTIME function doesn't work

[Piotr Przybylski]

If CURDATE works as a synonym to CURRENT_DATE, then CURTIME should also. Moreover, it's mentioned in docs: http://docs.drizzle.org/functions/current_time_functions.html

Using 2011.03.13 from Ubuntu 11.04 packages.

[Vijay Samuel (vjsamuel)]

Hi,
  Please make sure to add documentation for this as I believe that I ve
removed it since it was not working earlier.

Cheers,
-Vijay
On Sep 25, 2011 3:51 PM, "Matthew Rheaume" <email address hidden>
wrote:
> ** Changed in: drizzle
> Status: New => In Progress
>
> ** Changed in: drizzle
> Assignee: (unassigned) => Matthew Rheaume (mhrheaume)
>
> --
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
> https://bugs.launchpad.net/bugs/804570
>
> Title:
> CURTIME function doesn't work
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
Applications:
> In Progress
>
> Bug description:
> If CURDATE works as a synonym to CURRENT_DATE, then CURTIME should
> also. Moreover, it's mentioned in docs:
> http://docs.drizzle.org/functions/current_time_functions.html
>
> Using 2011.03.13 from Ubuntu 11.04 packages.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/drizzle/+bug/804570/+subscriptions

[Matthew Rheaume (mhrheaume)]

Certainly Vijay. I was wondering if it had been implemented earlier because there were a few references to Item_func_curtime in the comments, but I couldn't find an actual implementation anywhere. I'll make sure to document thoroughly.

Cheers,
-mhr

[Harsh vardhan verma (harshvardhan1991)]

There is no implementation for CURTIME() and CURRENT_TIME()( although CURDATE() and CURRENT_DATE() works), but these are still available in documentation.
http://docs.drizzle.org/functions/current_time_functions.html

admins should probably remove them from docs.

my experience with trial..

drizzle> select current_time();
ERROR 1305 (42000): FUNCTION current_time does not exist
drizzle> select curtime();
ERROR 1305 (42000): FUNCTION curtime does not exist
drizzle> SELECT CURTIME();
ERROR 1305 (42000): FUNCTION CURTIME does not exist
drizzle> SELECT CURTIME() + 0;
ERROR 1305 (42000): FUNCTION CURTIME does not exist
drizzle> SELECT current_time() + 0;
ERROR 1305 (42000): FUNCTION current_time does not exist