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.

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

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
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?

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

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