Monday, December 12, 2011

Calculating Age in MySQL

I was so thrilled with PostgreSQL's age function that I looked up the same for MySQL:

FLOOR((TO_DAYS(NOW())- TO_DAYS(date_of_birth)) / 365.25)
Posted at
Labels: ,

5 comments:

  1. Dr Purva PiusSeptember 8, 2016 at 5:25 AM

    Hello Everybody,
    My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of S$250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of S$250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius,via email:(urgentloan22@gmail.com) Thank you.

    BORROWERS APPLICATION DETAILS


    1. Name Of Applicant in Full:……..
    2. Telephone Numbers:……….
    3. Address and Location:…….
    4. Amount in request………..
    5. Repayment Period:………..
    6. Purpose Of Loan………….
    7. country…………………
    8. phone…………………..
    9. occupation………………
    10.age/sex…………………
    11.Monthly Income…………..
    12.Email……………..

    Regards.
    Managements
    Email Kindly Contact: urgentloan22@gmail.com

    ReplyDelete
  2. Dr Purva PiusMay 13, 2017 at 10:59 AM

    My name is.Mrs.Anna Daniel. I live in Ukraine i am a happy woman today? i need to use this time to tell all people how i got my loan from this honest and God fearing man loan lender that help me with a loan of $84,000 please contact him. if you also need a loan without any problem he name is Dr Purva Pius email (urgentloan22@gmail.com) tell him that is Mrs.Anna Daniel that refer you to he contact Email (urgentloan22@gmail.com)

    ReplyDelete
  3. nenisyahir@gmail.comApril 28, 2020 at 2:27 AM

    instagram: Aasimahaadilaaloanfirm
    twitter: ... aasimahaadilaahmedloanfirm
    E-mel: aasimahaadilaahmed.loanfirm@gmail.com


    salla Llâhu ‘alayhi wa sallam, nama saya Neni Syahir, saya adalah korban penipuan di tangan kreditor palsu. Saya kehilangan sekitar Rp.65.000.000 karena saya membutuhkan modal besar Rp. 5,5 miliar. Saya hampir mati, saya tidak punya tempat untuk pergi dan bisnis saya hancur, dan dalam proses itu saya kehilangan suami saya. saya tidak tahan lagi dengan hal ini. 4 November 2019 ini, saya bertemu dengan seorang teman lama di sebuah restuarant di Bandung yang memperkenalkan saya kepada seorang ibu yang baik, Ny. AASIMAHA ADILA MEMILIKI LOAN FIRM, yang akhirnya membantu saya mendapatkan pinjaman di sebuah perusahaan. Tolong, bantu saya untuk berterima kasih kepada ibu muslim yang memberikan pinjaman besar kepada pemilik perusahaan, pabrik burung hantu dan orang pribadi. Saya juga ingin menggunakan kesempatan ini untuk menasihati sesama orang Indonesia, Jika Anda ingin pinjaman modal besar, Anda dapat menghubungi mereka dan melihat situs web mereka Anda perlu tahu bahwa ada banyak scammers di blog ini yang tidak memiliki situs web di google map, saya menawarkan pinjaman dengan tingkat sangat rendah 1% dan saya mendapat pinjaman dalam 1 jam. .
    Kontak Aplikasi pinjaman besar

    E-mel: *******aasimahaadilaahmed.loanfirm@gmail.com
    WhatsApp ::: ************ + 447723553516
    Email saya; ***************** nenisyahir@gmail.com
    Bismillâh ar-ra.hmân ar-ra.hîm

    ReplyDelete
  4. UnknownJuly 29, 2020 at 9:10 PM


    Hello Everybody,
    My name is Mrs Elisa Safitri, I live in Singapore and i am a happy woman today! and I told my self that any lender that rescue my family from our poor situation, I will refer any person that is looking for loan to him, he gave me happiness to me and my family, I was in need of a loan of $250,000.00 to start my life all over as I am a single mother with 3 kids I met this honest and GOD fearing woman loan lender that help me with a loan of S$250,000.00 SG. Dollar, she is a GOD fearing woman, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Elisa, that refer you to him. contact Lady Nancy, via email:(helpinghandsintegratedloancomp@gmail.com)
    WhatsApp: +1 (312) 7419526 Thank you.

    ReplyDelete
  5. UnknownJuly 29, 2020 at 9:30 PM


    Hello Everybody,
    My name is Mrs Elisa Safitri, I live in Singapore and i am a happy woman today! and I told my self that any lender that rescue my family from our poor situation, I will refer any person that is looking for loan to him, he gave me happiness to me and my family, I was in need of a loan of $250,000.00 to start my life all over as I am a single mother with 3 kids I met this honest and GOD fearing woman loan lender that help me with a loan of S$250,000.00 SG. Dollar, she is a GOD fearing woman, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Elisa, that refer you to him. contact Lady Nancy, via email:(helpinghandsintegratedloancomp@gmail.com)
    WhatsApp: +1 (312) 7419526 Thank you.

    ReplyDelete

Subscribe to: Post Comments (Atom)