CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: SQL statement

  1. July 23rd, 2007, 10:50 AM #1
    gurupot
    gurupot is offline Member
    Join Date
    Nov 2003
    Posts
    107

    SQL statement

    Hi,

    I have a table with a date column which has data in this format 2003-01-31 09:03:05.303. I would like to extract the date from this column and format it to 20030131 format. Can anyone help me how to do this.

    Thanks,
    Pushpa
    Reply With Quote Reply With Quote
  2. July 23rd, 2007, 03:49 PM #2
    ka3ak
    ka3ak is offline Member
    Join Date
    Dec 2002
    Location
    Kiev, Ukraine
    Posts
    61

    Re: SQL statement

    i'm not sure which dbms you're using, but if it's mysql, check this out: http://dev.mysql.com/doc/refman/5.0/...functions.html
    Reply With Quote Reply With Quote
  3. July 23rd, 2007, 06:02 PM #3
    dglienna's Avatar
    dglienna
    dglienna is offline ex MVP - Visual Basic Power Poster
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: SQL statement

    Please read the FAQ's about posting your DB so we don't have to guess.
    How'd you get mySql out of that?
    David

    CodeGuru Article: Bound Controls are Evil-VB6
     2013 Samples: MS CODE Samples
    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!
    Reply With Quote Reply With Quote
  4. July 24th, 2007, 07:04 AM #4
    ka3ak
    ka3ak is offline Member
    Join Date
    Dec 2002
    Location
    Kiev, Ukraine
    Posts
    61

    Re: SQL statement

    mysql is the domain i most often work in, perhaps it is also the domain of the OP... i'm not hating on MS :-D
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured