convert date format MMMM yyyy to yyyyMM in asp.net vb

Question

i have textbox that contain string month and year value, example: January 2010

but i want to save it into mysql database with format 201001 --->year and then number of month

how can i convert this string?

are you saving the date as string in mysql ? What is the column type in your database table — Habib, May 22 '13 at 05:55
@Habib, yes i want to save it into mysql table, the coloumn type is varchar(6) — sephtian, May 22 '13 at 05:59

score 3 · Accepted Answer · edited May 23 '17 at 10:25

3

Based from this link, maybe you can try this:

Dim dateval As String = "January 2010"
Dim year As String = dateval.Split(" "C)(1)
Dim month As String = DateTime.ParseExact(dateval.Split(" "C)(0), "MMMM", CultureInfo.CurrentCulture).Month.ToString()

Dim yourdateval As String = String.Concat(year, month)

edited May 23 '17 at 10:25

Community

1
1

answered May 22 '13 at 06:20

iceheaven31

877
1
13
23

wow that's good idea, but it give me 1 digit month number, i want to get 2 digit month number :( – sephtian May 22 '13 at 06:24
1

then maybe you can just make a condition to append a '0' before the month if it is a one digit number.. – iceheaven31 May 22 '13 at 06:25
1

well i tought there's no other way :) – sephtian May 22 '13 at 06:34
here the answer for 2 digit month number http://stackoverflow.com/questions/3662292/converting-month-name-to-integer/3662360#comment24026218_3662360 – sephtian May 23 '13 at 01:33

convert date format MMMM yyyy to yyyyMM in asp.net vb

1 Answers1