Re: VB transformation to SQL Server datetime

"PSULionRP" <PSULionRP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A6E9DBF2-AA8E-478B-BDEA-93E1055820DB@xxxxxxxxxxxxxxxx

Is there any way to transform date and time insto a SQL Server Table
datetime
format???

I understand the ramifications of the SQL Server datetime column
definition.
And I understand that I might have to handle this through SQL Server
rather
than VB. Just looking for confirmation.

There is NO "format." Dates are dates when they are contained variables
defined as dates. If your date is in a STRING, or you're somehow dealing
with strings at some point in the process (like building dynamic SQL--which
is very often a bad idea), then there's an issue. Please provide more
details.


.

Relevant Pages

  • VB transformation to SQL Server datetime
    ... I understand the ramifications of the SQL Server datetime column definition. ...
    (microsoft.public.vb.general.discussion)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cannot Generate SSPI Context - help
    ... I have used the following DSN-less string: ... Microsoft OLE DB Provider for SQL Server error '80004005' ... When a connection is "trusted," it means ... > How would one connect to a remote SQL Server using Windows authen? ...
    (microsoft.public.inetserver.asp.db)
  • Re: ADO.NET 2.0 saving single space to SQL?
    ... It is code someone else wrote quite some time ago and all of the string ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: INSERT Query problem with Quotes & Apostrophes
    ... I've got front-ends that go against both Jet and SQL Server databases. ... InputText As String, _ ... >> Delimiter, Delimiter & Delimiter) ... dDateTime, ...
    (microsoft.public.access.modulesdaovba)