Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
dbcovert() replacement in ODBC

Unanswered dbcovert() replacement in ODBC

  • Thursday, November 29, 2012 10:03 PM
     
     
    Sign In to Vote
    0

    Hello,

    What is the replacement(api) of dbconvert (dblibrary api) in odbc native client?

    If there isn't one.......how do we convert from datetime string (yyyymmdd hh:mm:ss.sss) to DBDATETIME?

    Thanks

     

All Replies

  • Friday, November 30, 2012 12:47 PM
     
     
    Sign In to Vote
    0

    Hello, can some one answer this que....as this is an urgent issue.

    Thanks in advance.

     
  • Friday, November 30, 2012 1:19 PM
    Moderator
     
     
    Sign In to Vote
    0

    What is the replacement(api) of dbconvert (dblibrary api) in odbc native client?

    If there isn't one.......how do we convert from datetime string (yyyymmdd hh:mm:ss.sss) to DBDATETIME?

    I don't know if there is an exact replacement for dbconvert but a standard ODBC format for timestamp literals is yyyy-mm-dd hh:mm:ss.sss.  You might try simply adding the dashs to the date.

    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/