Microsoft access sql convert date to string

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Access Date Time convert to string. Time is stored as Military, Don't want to convert Ask Question. Asked 5 years, 7 months ago. Active 5 years, 7 months ago. Viewed 2k times. The two fields are DateTime.

BeginTime,"hh:mm" , I get PM instead of John John 69 3 3 silver badges 17 17 bronze badges. The format comes whenever you display the value.

If it's just in the debugger then you don;t need to worry about it. Add a comment. Active Oldest Votes. So I tried a few things in Access and it seems that Bjones has a point. BeginTime,"HH:mm" cDate transforms the content to a date but it doesn't format it. This discussion thread is closed Start new discussion.

Similar topics Java. Convert a string to a date. Convert a string containing a bit binary date to a date data type. Convert Date pb. How to convert a date string to datetime value with custom date format? Converting a date string to a DateTime. Example please.

Visual Basic. How to convert user-defined custom format date string to date value. Convert date recevied as String to date in local time zone. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.