Saving a datetime from DatePicker as a string in custom format VB.net

Question

I am using a MS Datepicker to capture a date and need to save it to my SQLdb as a sting in the following format: yyyymmdd. How do I convert the value from the DateTimePicker either in VB or in SQL?

example: 3/1/2018 should be 20180301 etc...

If it is a` DateTime, you should save it as a DateTime` so it acts like a DateTime and doesnt need the be converted when reading or writing. — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Feb 23, 2018 at 17:27
I'm using a DB that was built years ago and don't have much flexibility to change it. The original designer did it this way and I am trying to work within the bounds that I have. — Levi
– Levi, Commented Feb 23, 2018 at 18:29

John Cappelletti · Accepted Answer · 2018-02-23 17:01:15Z

1

Storing dates as strings is always questionable, however, it you must

Example

Select convert(varchar(8),convert(date,'3/1/2018'),112)

or if 2012+

Select format(convert(date,'3/1/2018'),'yyyyMMdd')

Returns

20180301

answered Feb 23, 2018 at 17:01

John Cappelletti

82.3k7 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KeithL · Accepted Answer · 2018-02-23 17:01:30Z

0

well C# is:

[DateTiemVar].ToString("yyyyMMdd") ;

I have to assume it is very siomilar in VB.

answered Feb 23, 2018 at 17:01

KeithL

5,6193 gold badges23 silver badges30 bronze badges

Comments

Naveed · Accepted Answer · 2018-02-26 06:12:11Z

0

You can do like this, suppose cDate is you field name

SELECT STR_TO_DATE(cDate,'%m/%d/%Y %h:%i:%s %p') as cDate;

answered Feb 26, 2018 at 6:12

Naveed

592 silver badges13 bronze badges

Collectives™ on Stack Overflow

Saving a datetime from DatePicker as a string in custom format VB.net

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related