Query SQL LDAP import

343
April 21, 2017, at 9:51 PM

I am doing an ldap import into a DB, the specific area of interest is the date created attribute.

Currently as per screenshot, this is in a long string and I would like to pick it apart so it displays in a date/time format. enter image description here

The format I would like is DD-MM-YYYY all of the other information can be excluded.

LAST QUESTIONS
All questions
POPULAR ONLINE
jQuery Categories

Getting the width after resizing end using jQuery resizable

storm error EOF while reading from storm

Digital Envelope Routines: Bad Decrypt

Network access to MySQL in MAMP 4 Windows

Failed syntax UPDATE id in MariaDB

READ ALSO
Importing a CSV file into Heidi SQL and I get SQL Error 1300: Invalid uft8 character string
MySQL

Importing a CSV file into Heidi SQL and I get SQL Error 1300: Invalid uft8 character string

The CSV is an export from Majestic, the SEO backlink software, and is formatted as a utf8 CSV

 366
Where is the syntax error in this sql query?
MySQL

Where is the syntax error in this sql query?

 192
How do we select the student who takes all classes taught by Davidson and how to select all the teacher's name who teaches atleast 3 classes?
MySQL

How do we select the student who takes all classes taught by Davidson and how to select all the teacher's name who teaches atleast 3 classes?

all! I'm taking database class and have couple of questions that is so confusing to medown below is my table

 202
error when inserting point value in point column for Geo coordinates
MySQL

error when inserting point value in point column for Geo coordinates

I'm having a point column and now i wan't them to populate it with point value which is calculated with GeomFromText(POINT(45713958 14

 172