RE: extract year-month-day-hour

2014-09-18 Thread Prashant Ramhit
__ From: Mihail Manolov [mihail.mano...@liquidityservices.com] Sent: 19 September 2014 03:20 To: Cc: mysql@lists.mysql.com Subject: Re: extract year-month-day-hour Try this: LEFT('2014-09-17 12:22:16', 13) Mihail Manolov Senior Manager, Database Liquidity Servic

Re: extract year-month-day-hour

2014-09-18 Thread Mihail Manolov
18:31, 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" > > The reason for this is I

Re: extract year-month-day-hour

2014-09-18 Thread Peter Brawley
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( tsval

extract year-month-day-hour

2014-09-18 Thread Jopoy Solano
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 cons