9
Answers

How to cast or convert the Date time in dd/mm/yyyy

Abhimanyu Singh

Abhimanyu Singh

12y
6.3k
1
hey all hiii,

Hello all, i am new in this field and want some halp from all you.
Actually i have fetched the date only from system.But its having format like mm/dd/yy
but i want like that dd/mm/yy

following arethe .cs code:

insert code: 

con.Open();

SqlCommand cmd = new SqlCommand("insert into contact_us (Name,Email_id,Mobile_no,Comments, entry_date ) values('"+TextBox1.Text+"','"+TextBox2.Text+"','"+TextBox3.Text+"','"+TextBox4.Text+"', '"+System.DateTime.Today.ToShortDateString() +"' )",con);

SqlDataReader dr = cmd.ExecuteReader();

con.Close();

for fetching:

        con.Open();

        SqlDataAdapter da = new SqlDataAdapter("select Name as'Name', Email_id as 'Email Id',Mobile_no as 'Mobile No',Comments as 'Comment', CONVERT(VARCHAR(20),entry_date,111) from contact_us", con);

        DataSet ds = new DataSet();

        da.Fill(ds);

        DataTable dt = ds.Tables[0];

        GridView1.DataSource = dt;

        GridView1.DataBind();

        con.Close();




Answers (9)
1
Jim Stroke

Jim Stroke

NA 492 2 11y
You can find various solutions on having a google search for your problem.
Or you can have a look at the following link: Apple mail to Pst Windows


Hope this will help.
Thank you
Accepted
0
Andew Condon

Andew Condon

NA 4 1 8y
Try Mail Extractor Pro, if you are looking for Apple Mail / MBOX to PST Converter for Mac Version.
Get More Info:http://www.mailextractorpro.com
0
Stephen Ronald

Stephen Ronald

NA 12 0 9y

You need to copy Apple Mail MBOX file to Windows machine and convert it to PST format. For that you can use a smart Apple mail to Outlook converter for Windows. The tool extract all email messages from MBOX file and save them to an importable PST format.

Download from: http://www.mboxtooutlook.org/convert/applemail.html 

0
David Brenner

David Brenner

NA 5 1.7k 10y
I just tried the new mac version of the same tool Apple Mail to pst Converter

M
uch faster than the windows version and auto-detects the apple mail email files. Being a user the only thing I needed to do was transfer the converted pst file and import it into windows outlook.
0
William Wall

William Wall

NA 3 1.5k 11y
Thanks for the solution.
0
Tony Gump

Tony Gump

NA 922 5 11y
A quick and easy way to do this is with a GMail IMAP account. Just setup the GMail account on the Mac and in Outlook on Windows. Then in Mail (Mac) drag the messages from your account to the GMail IMAP folders (make as many as you need). Now in Outlook drag the messages from the GMail IMAP account into the Outlook folders you want.

Another way is to go fro third party applications. 
The one I know is : Apple Mail to PST Convert – Convert Apple Mail Emails to WIndows Outlook PST

Using third party applications has the advantage of doing the migration quickly while the imap account method is slow and lengthy.

Choose the way you want to opt.
Thank you