C / C++ / MFC

_AnsHUMAN_ 6-Jun-06 1:43

6-Jun-06 1:43

<br />
    CString m_cdate;<br />
    SYSTEMTIME sysTime;<br />
GetSystemTime (&sysTime);<br />
    // Correction here<br />
    m_cdate.Format("%04d-%02d-%02d", sysTime.wYear, sysTime.wMonth,                sysTime.wDay);

Now write it to the table

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

-- modified at 9:42 Tuesday 6th June, 2006

p_6-Jun-06 3:20

6-Jun-06 3:20

yar this will give problem that GetYear(),GetMonth(), GetDay() are not member of SYSTEMTIME if ucan find solution mail me at gourav_d1983@indiatimes.com

hi

_AnsHUMAN_ 6-Jun-06 3:37

6-Jun-06 3:37

Use this code //

<br />
<br />
	SYSTEMTIME sysTime;<br />
	GetSystemTime(&sysTime);<br />
	CString s;<br />
	s.Format("%04d/%02d/%02d",sysTime.wYear ,sysTime.wMonth,sysTime.wDay);<br />
	AfxMessageBox (s);<br />
<br />

Does this work ........
It will................
Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

-- modified at 9:37 Tuesday 6th June, 2006

_AnsHUMAN_ 6-Jun-06 3:32

6-Jun-06 3:32

I tried and tested the code on my machine and it runs well producing the desired output.
Any ways you can try using CTime as Laxman suggested or use COleDateTime

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

yogendra kaushik6-Jun-06 19:40

6-Jun-06 19:40

sorry to disturb u again ur query give correct ans
but my problem is that i want to display not only current date but also other dates whiich i specify on form and that are stored in mysqltable
how other dates r stored in table

gourav dogra jfjunf

_AnsHUMAN_ 6-Jun-06 19:51

6-Jun-06 19:51

When you are retreiving those dates from the table they would be in string format as I guess. So you just have to format the strings using the
CString::Format() , to get the date in the desired manner and display it then . Post some code so that the problem can be traced out

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

yogendra kaushik6-Jun-06 19:58

6-Jun-06 19:58

As i use date time picker in vc++ form so now set a date on it and i want that this date is stored in mysql table but always it store current date.
i uses the code as u tel me code is:

SYSTEMTIME sysTime;
GetSystemTime(&sysTime);
CString s;
s.Format("%04d/%02d/%02d",sysTime.wYear ,sysTime.wMonth,sysTime.wDay);

now i want to srore other than systemdate in mysql table that is to store "1999-09-03" but when i set this date on date time flicker it will store today date as 2006-06-07

gourav dogra jfjunf

_AnsHUMAN_ 6-Jun-06 20:10

6-Jun-06 20:10

I think that you are having a problem in the way you are thinking and asking.
Soln:
m_datetime is the datetime control.
Now when the user modifies the date in the control you can use the following code to get the date that the user had selected in the control

    m_datetime .UpdateData();
char *str=new char[100];
m_datetime.GetWindowText (str,10);
    AfxMessageBox(str);

// str has the date.
//Extract the date from str and now continue.
Now are you able to get the soluction or some other problem

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

-- modified at 2:11 Wednesday 7th June, 2006

yogendra kaushik6-Jun-06 20:27

6-Jun-06 20:27

sur my problem is i enter date in date time picker and code read this value through the :
GetDlgItemText(IDC_DATE,jdate)
where IDC_DATE is id of date time picker and jdate store this value
and i declare this jdate as CString.

now i want that value from GetDlgItemText(IDC_DATE,jdate) is stored into mysql table which i specify
i try this code what as i tel u i use jdate instead of m_datetime then it give errors
m_datetime .UpdateData();
char *str=new char[100];
m_datetime.GetWindowText (str,10);
AfxMessageBox(str);

gourav dogra jfjunf

_AnsHUMAN_ 6-Jun-06 20:33

6-Jun-06 20:33

Please quote the errors. Try to get the values using GetWindowText. I have already tested the code above that i provided you in this thread earlier.

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

yogendra kaushik6-Jun-06 20:52

6-Jun-06 20:52

when i declare
CString jdate;
GetWindowText(IDC_DATE,jdate);
jdate .UpdateData();
char *str=new char[100];
jdate.GetWindowText (str,10);
AfxMessageBox(str);
F:\gourav\DOGRAPROJECT\AgainDialog.cpp(196) : error C2664: 'int __thiscall CWnd::GetWindowTextA(char *,int) const' : cannot convert parameter 1 from 'const int' to 'char *'
Conversion from integral type to pointer type requires reinterpret_cast, C-style cast or function-style cast
F:\gourav\DOGRAPROJECT\AgainDialog.cpp(197) : error C2039: 'UpdateData' : is not a member of 'CString'
c:\program files\microsoft visual studio\vc98\mfc\include\afx.h(368) : see declaration of 'CString'
F:\gourav\DOGRAPROJECT\AgainDialog.cpp(199) : error C2039: 'GetWindowTextA' : is not a member of 'CString'
c:\program files\microsoft visual studio\vc98\mfc\include\afx.h(368) : see declaration of 'CString'
F:\gourav\DOGRAPROJECT\AgainDialog.cpp(205) : error C2065: 's' : undeclared identifier
F:\gourav\DOGRAPROJECT\AgainDialog.cpp(205) : error C2666: '+' : 4 overloads have similar conversions
Error executing cl.exe.

DOGRAPROJECT.exe - 5 error(s), 0 warning(s)

no plz hwlp me i am very confused with this and cannot undestand wat to do

gourav dogra jfjunf

_AnsHUMAN_ 6-Jun-06 21:00

6-Jun-06 21:00

First of all jDate should not be a string . It should be a control variable for the date time control. Create it using the class wizard and don't take it as a value take it as a control

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

_AnsHUMAN_ 6-Jun-06 21:01

6-Jun-06 21:01

Have a look at my previous post carefully. You will find that the variable m_datetime should be a control variable and not a string type variable and then use the code provided in the previous post

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

p_6-Jun-06 21:42

6-Jun-06 21:42

///////////plz do reply///////////////

thanks this will works but how itwill be converted into mysql format

m_datetime .UpdateData();
char *str=new char[100];
m_datetime.GetWindowText (str,10);
AfxMessageBox(str);
now how can i convert str into string so that iw will store in mysql table;

can i convert it wuth this but as str is not redefined so wat can i do now
SYSTEMTIME m_jdate;
GetSystemTime(&m_jdate);
CString s;
s.Format("%04d/%02d/%02d",m_jdate.wYear ,m_jdate.wMonth,m_jdate.wD

hi

-- modified at 4:11 Wednesday 7th June, 2006

Laxman Auti6-Jun-06 1:43

Laxman Auti

6-Jun-06 1:43

paras_s12 wrote:
can i know how to store a date format dd-mm-yyyy as in mfc in to
mysql table in the format yyyy-mm-dd send code plz

Format the date as

CTime t;
CString strdate=t.Format("%Y-%m-%d");

Knock out 't' from can't,
You can if you think you can
Cool | :cool:

David Crow6-Jun-06 3:28

David Crow

6-Jun-06 3:28

See here.

"The largest fire starts but with the smallest spark." - David Crow

"Judge not by the eye but by the heart." - Native American Proverb

p_6-Jun-06 3:48

6-Jun-06 3:48

it works thanku for this but it will not display other date
it display only current date
is it possible if then tel me how

hi