ADO adDBtimeStamp maps to a DATETIME type in SQL Server

I have a smalldatetime in SQL table, and I want to get this datetime
in the format yyyy-mm-dd hh:mm, but acorss ADO, I got yyyy-m-d
format. This is not I will. One way I thought is converting the
smalldatetime to a string. And this's not a elegant way. Because in
the case, I have to change many sql sentences to fix the problem.
Any suggestion? Thanks in advance.

.

Relevant Pages

  • ODBC/VBA?EXCEL and ORACLE database
    ... We recently converted one of our datawarehouses to ORACLE. ... I am now having difficulty converting several Excel Macros that use VBA ... With a SQL Syntax error. ... function is required to override ORACLE default format of:date Timestamp" ...
    (microsoft.public.excel.programming)
  • Access To SQL
    ... I'm converting an Access 2000 database to SQL 2000. ... be creating a Web front end and need to know how to conditionally format HTML ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Date format
    ... smalldatetime actually has no format. ... Using SmallDateTime in SQL Table, how can I enforce M/DD/YY format on ... output of DTS package is MM/DD/YY format. ...
    (microsoft.public.sqlserver.dts)
  • DateTime problem: how to create datetime format hh:mm:ss AM/PM without the date
    ... my database has separate field for date and time so we can capture ... In Sql, date can be present in smalldatetime ... format, which contains only time hh:mm:ss AM/PM. ...
    (microsoft.public.dotnet.languages.csharp)
  • Date transforms from dd/mm/yyyy to mm/dd/yyyy - why?
    ... I'm loading some tables via DTS with the input files being comma ... For 2 date fields (format =smalldatetime in sql) if I pass a value of: ...
    (microsoft.public.sqlserver.dts)