Hello,
Try these in build functions from MySQL
mysql> select year('2014-09-17 12:22:16'), month('2014-09-17 12:22:16'),
day('2014-09-17 12:22:16'), hour('2014-09-17 12:22:16');
+
Prashant Ramhit
Administrator - Performance Mgt Systems
Emtel Ltd.
Mobile: +230 5 499 4911
Sent from my Emtel Smart D
Try this:
LEFT('2014-09-17 12:22:16', 13)
Mihail Manolov
Senior Manager, Database
Liquidity Services, Inc.
1920 L Street NW
Washington DC 20036
202-467-6868 x3227 (Office)
202-256-9044 (Mobile)
mihail.mano...@liquidityservices.com
LiquidityServicesInc.com
> On Sep 18, 2014, at 18:31, Jopoy Sol
On 2014-09-18 5:25 PM, Jopoy Solano wrote:
Hi!
I want to say sorry in advance for my ignorance. I was wondering how can I
extract year-month-day-hour in one go. For example:
>From "2014-09-17 12:22:16" to "2014-09-17 12"
Is this what you mean?
date_format( tsvalue, '%Y-%m-%d %H' )
PB
-
Hi!
I want to say sorry in advance for my ignorance. I was wondering how can I
extract year-month-day-hour in one go. For example:
>From "2014-09-17 12:22:16" to "2014-09-17 12"
The reason for this is I'm trying to generate how much data users
historically consume every hour for each day.
Than
Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:
" Database Workbench 5 "
Version 5.0.2 fixed some issues that came to light after the initial
major version 5 release.
http://www.upscene.com/news/item/20140918
Version 5 adde