Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006

    Unanswered: how can i extract date from datetime

    hi sir
    i m using vicidial.i have a CRM project in which i can access the asterisk database.but i have a problem in accessing some records


    in the vicidial_agent_log table event_time fields datatype formate is like that
    2006-09-15 00:00:00 but that formate not supported by VB.NET.
    so how i can access only date from this.

    i was trying with changing datatype DATETIME to DATE.but by query it takes default time 12:00 AM automatically.

    can u have some guidence ,about that how can i extract only date from datetime


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    if you need the date in a sepecific format consioder using the the date formatting within MySQL as part of the SQL. I wouldn't normally suggest doing that as you risk loosing the abilitiy to sort on the date column or use it as a value in the front end.

    It should be possible in the extract the data from MySQl in a foramt that VB.NET can use
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts