C / C++ / MFC

If the high-order word of wParam contains 0xFFFF and the lParam parameter contains NULL, the system has closed the menu.

SYSTEMTIME *DBStatement::GetDate(int iColumnNum, SYSTEMTIME *spDateTime /*=NULL*/)
{
  short iStatus = -1;

  if (!spDateTime)
    spDateTime = &m_sDateTime;

  memset(spDateTime,0,sizeof(SYSTEMTIME));

  if (m_hStmtHdl)
    {
      ResetError();

      SQL_TIMESTAMP_STRUCT sTS;
      long lColSize = 0;

      iStatus = ::SQLGetData(m_hStmtHdl,iColumnNum,SQL_C_TIMESTAMP,&sTS,sizeof(SQL_TIMESTAMP_STRUCT),&lColSize);
      if (iStatus == SQL_SUCCESS || iStatus == SQL_SUCCESS_WITH_INFO)
        {
          if (iStatus == SQL_SUCCESS_WITH_INFO)
            iStatus = SQL_SUCCESS;

          SetNullValue(lColSize == SQL_NULL_DATA);
          if (lColSize != SQL_NULL_DATA)
            {
              spDateTime->wYear = sTS.year;
              spDateTime->wMonth = sTS.month;
              spDateTime->wDay = sTS.day;
              spDateTime->wHour = sTS.hour;
              spDateTime->wMinute = sTS.minute;
              spDateTime->wSecond = sTS.second;
              // spDateTimeStruct->wMilliseconds = (USHORT)sTS.fraction;
            }
        }
      else
        UpdateDBError();
    }
  else
    NoActiveStatement();

  return spDateTime;
}

time_t now;<br />
struct tm *localNow;<br />
TIMESTAMP_STRUCT tsOpenDate;<br />
char* szStmt = "INSERT INTO ORDERS (ORDERID, CUSTID, OPENDATE, SALESPERSON, STATUS) VALUES (?, ?, ?, ?, ?)";<br />
<br />
SQLDescribeParam(hstmt, 3, &DataType, &ParamSize, &DecimalDigits, &Nullable);<br />
SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_TYPE_TIMESTAMP, SQL_TYPE_TIMESTAMP, ParamSize, DecimalDigits, &tsOpenDate, 0, &cbOpenDate); <br />
<br />
time (&now);<br />
localNow = localtime (&now);<br />
<br />
tsOpenDate.year = localNow->tm_year;<br />
tsOpenDate.month = localNow->tm_mon;<br />
tsOpenDate.day = localNow->tm_mday;<br />
tsOpenDate.hour = localNow->tm_hour;<br />
tsOpenDate.minute = localNow->tm_min;<br />
tsOpenDate.second = localNow->tm_sec;<br />
tsOpenDate.fraction = 0;

	Ctime time;<br />
        CString m_appdate;<br />
	time = time.GetCurrentTime();<br />
	m_appdate = time.Format("%d-%m-%y");<br />
	const char *appdate = (LPCTSTR)m_appdate;<br />
	SQLINTEGER cappdate = SQL_NTS;<br />
<br />
<br />
	sr = SQLBindParameter(hstmt,6,SQL_PARAM_INPUT,<br />
		SQL_C_TCHAR,SQL_C_TCHAR,10,0,<br />
		(void *)appdate,sizeof(appdate),&cappdate);<br />
	if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)<br />
	{<br />
		displayError(sr,"Error in Binding 6");<br />
	}

time (&now);<br />
localNow = localtime (&now);<br />
printf ("%s", asctime (localNow));<br />
<br />
memset (&tsOpenDate, 0, sizeof(tsOpenDate));<br />
tsOpenDate.year = localNow->tm_year + 1900;<br />
tsOpenDate.month = localNow->tm_mon + 1;<br />
tsOpenDate.day = localNow->tm_mday;<br />
tsOpenDate.hour = localNow->tm_hour;<br />
tsOpenDate.minute = localNow->tm_min;<br />
tsOpenDate.second = localNow->tm_sec;

SYSTEMTIME systemTime;<br />
GetLocalTime (&systemTime);<br />
<br />
memset (&tsOpenDate, 0, sizeof(tsOpenDate));<br />
tsOpenDate.year = systemTime.wYear;<br />
tsOpenDate.month = systemTime.wMonth;<br />
tsOpenDate.day = systemTime.wDay;<br />
tsOpenDate.hour = systemTime.wHour;<br />
tsOpenDate.minute = systemTime.wMinute;<br />
tsOpenDate.second = systemTime.wSecond;<br />