---
title: "C to SQL: Date | Microsoft Docs"
ms.custom: ""
ms.date: "01/19/2017"
ms.prod: sql
ms.prod_service: connectivity
ms.reviewer: ""
ms.technology: connectivity
ms.topic: conceptual
helpviewer_keywords: 
  - "date data type [ODBC]"
  - "converting data from c to SQL types [ODBC], date"
  - "data conversions from C to SQL types [ODBC], date"
ms.assetid: bea087d3-911f-418b-b483-d2b5b334da19
author: David-Engel
ms.author: v-daenge
---
# C to SQL: Date
The identifier for the date ODBC C data type is:  
  
 SQL_C_TYPE_DATE  
  
 The following table shows the ODBC SQL data types to which date C data may be converted. For an explanation of the columns and terms in the table, see [Converting Data from C to SQL Data Types](../../../odbc/reference/appendixes/converting-data-from-c-to-sql-data-types.md).  
  
|SQL type identifier|Test|SQLSTATE|  
|-------------------------|----------|--------------|  
|SQL_CHAR<br /><br /> SQL_VARCHAR<br /><br /> SQL_LONGVARCHAR|Column byte length >= 10<br /><br /> Column byte length < 10<br /><br /> Data value is not a valid date|n/a<br /><br /> 22001<br /><br /> 22008|  
|SQL_WCHAR<br /><br /> SQL_WVARCHAR<br /><br /> SQL_WLONGVARCHAR|Column character length >= 10<br /><br /> Column character length < 10<br /><br /> Data value is not a valid date|n/a<br /><br /> 22001<br /><br /> 22008|  
|SQL_TYPE_DATE|Data value is a valid date<br /><br /> Data value is not a valid date|n/a<br /><br /> 22007|  
|SQL_TYPE_TIMESTAMP|Data value is a valid date[a]<br /><br /> Data value is not a valid date|n/a<br /><br /> 22007|  
  
 [a]   The time portion of the timestamp is set to zero.  
  
 For information about what values are valid in a SQL_C_TYPE_DATE structure, see [C Data Types](../../../odbc/reference/appendixes/c-data-types.md), earlier in this appendix.  
  
 When date C data is converted to character SQL data, the resulting character data is in the "*yyyy*-*mm*-*dd*" format.  
  
 The driver ignores the length/indicator value when converting data from the date C data type and assumes that the size of the data buffer is the size of the date C data type. The length/indicator value is passed in the *StrLen_or_Ind* argument in **SQLPutData** and in the buffer specified with the *StrLen_or_IndPtr* argument in **SQLBindParameter**. The data buffer is specified with the *DataPtr* argument in **SQLPutData** and the *ParameterValuePtr* argument in **SQLBindParameter**.