Saturday, March 6, 2010

Concatenate Date and Time From Two Fields -- MySQL

Example
In this example, I'm checking whether a time slot in a schedule table is in the future.

SELECT * FROM table
WHERE concat(date(appt_date)," ",time(start_time)) > NOW( )
ORDER by appt_date desc, start_time desc, end_time desc

12 comments:

Anonymous said...

In my opinion you commit an error. Let's discuss it.

Anonymous said...

discount cialis levitra viagra bean jumping mexican levitra Discount kamagra oral jelly online free consult Cheap Online Buy Ditropan order Levitra online no membership overnight shipping Levonorgestrel Cheap No Rx Required Canada buy cheap Levitra cod canada Flomax (Tamsulosin) overnight Flomax ultram buy lexapro online canadian no script diflucan with no perscription and delivered over night

Anonymous said...

Clomid generic Cephalexin tablets to buy online lipitor saturday delivery cod Prograf Saler provera cream for men Clomid rezept cod saturday Levitra generic pal pay cephalexin Buy Keflex online canada without presciption using cialis

Anonymous said...

Levitra no script needed cod overnight Legally Order Lasix cheap Lipitor UK cheap Kamagra cheapest jelly kamagra uk only Premarin Next Day Cod Fedex purchase Amoxil in Winnipeg Buy Retin A without prescription needed weaning off lexapo buy prograf doctor prescription

Anonymous said...

buy buy AUGMENTIN now online tadalafil generic no prescription cialis can an ohio pa prescribe Best Augmentin pills online cialis rezeptfrei europa cialis eckert order avodart uk Cephalexin No Rx Saturday Delivery bad side effects of cephalexin Order buy Boniva now online

Seller John said...

Viagra Online in Texas Buy Viagra for lowest prices! Cheap Viagra online is guaranteed! ORDER VIAGRA - CLICK HERE! We provide only HIGH QUALITY Viagra. Cialis and Viagra Blog. About Cialis and Viagra.

We Make Buying Cialis Easy. Whether you're a first-time Cialis online buyer or want to Buy Cialis for your first time, we can help with all your buying questions - from how to buy cialis online to clinical Cialis data.

Anonymous said...

kazar sklep internetowy
to torebki , torby , torebki david jones . torebki skórzane damskie , torebki damskie ?

viagra online said...

I've study it for long time actually The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements.m10m

kamagra1uk said...

When you’re thinking about having a little bit more fun in the bedroom, but you know that your problem is holding you back then it is time to search out a product that is able to help you achieve the goals that you have. Never have to worry again about not being able to perform, to show off and to be the man she wants you to be when it comes down to being intimate. When you want to show her just how much a man can love her, then you will have to check into what Kamagra can do for your love life, for her and for your own self esteem.
Kamagra | Buy Kamagra UK | Cheap Kamagra UK

kamagra1uk said...

Kamagra is a product that can be taken orally, in a little pill form, that provides men suffering from ED with a way to have a healthy sexual lifestyle without having to worry about the condition getting in the way. Proven to be one of the most effective ways to treating and helping the problem out, it is one of the top leaders in the industry for men suffering from ED associated problems.
Kamagra | Buy Kamagra UK | Cheap Kamagra UK

donnaj edwards said...

Thanks a lot for sharing this amazing knowledge with us. This site is fantastic. I always find great knowledge from it.  Kamagra Online

Herbal Remedy is 100% guarantee for Penis Enlargement said...

I want to share this wonderful testimony to the Good people all over the world on how I was able to Enlarge my Penis by Dr. Aziba. I was living a shameful life from my young age, just last month as I was browsing on the internet about Penis size and Enlargement Products, I saw a testimony of a Man called George , testifying of how he was able to get his penis Enlarged by Dr. Aziba and I decided to also Email Dr. Aziba for my small penis size and he quickly respond to me and gave me the normal instructions which i did and then he shipped the product to me here in the united state which i received in just 3 working days and today i am very happy because i started seeing positive changes in my penis size in just 7 days of use. Dr Aziba herbal product is the best recommended for you and to whom ever suffering from this shame or having any other diseases as well should Contact this great herbal doctor via his Email : Priestazibasolutioncenter@gmail.com and WhatsApp Him on +2348100368288