To find the date of account created

This query is marked as a draft This query has been published by Ananth subray.
SQL

use knwiki_p;
select user_name,DATE_FORMAT(user_registration, "%D/%M/%Y %H:%i:%s") from user where user_name in ("1840570chaithra","1804587","1810116sushmalikhitha.l","1810147dhananjaya.s","1810148girish.p","1810149g","1810150harishkumar","1810151Nithish s","1810152raj","1810153rohanr","1810154sagar","1810156yathin","1810157cicilyajencys","1810159harshithamaria","1810161jyothikadeepashree","Kalyani.s1810162","1810163KavyaSR","Madhu","1810165mani","1810166monica","nanditha1810167","priya1810168","Risha1810169","1810170sahana","1810171saikeerthana","1810172sangeetha","1810174suma","1810190 Vibha","1810209 Suhas m","sunil1810210","Pooja1810216","1810217priyanka","1810248achyu","1810249akshay","1810250 Amith","1810251","1810252b","1810253chetan.r","1810254 Daniel","1810256glemin","1810257hemanth.tm","1810258msprasidh","1810259manish.s","1810260nagi","1810261prakash.m","1810262vijay","1810263sandesha","1810264shanthraj.A","1810265shreedhar","1810266apoorva","1810268beulah","1810270chaitra","1810271deeksha","1810272gowri","1810274monica","1810275petrisha","RPrerana1810276","ramya1810277","1810279sanjana","1810280vedikaguptha","1810281v","harshithp1810288","PREM.PKG","Deekshith Devaiah K J","1810350m","Preran S","Sumukha sharma M","Sunilkumar t1810355","Varun1810356","Zameer pasha M S","Berndene Trinishya","Bhagya Shree L B 1810361","Chaithra S","Damini n reddy","HARSHITHA SHIVAKUMAR","Likitha N S","Meghana. B. S","Monisha DG","PALLAVI BS","Pushpa R","SPOORTHY M U","SUJITHA MARY A","S Tejaswini","Tejaswini T","Vennala ml","PARTHANARAYANA K R","Keerthana j","Akshay TL","ANUSH AV03","ASHOKA P T","Chethan Kumar B K","Chinmaya S Padmanabha","Edwin Sunny ej creations","JOSEPH JACKSON 002","Kaushik Srinivasa Rachakonda","Kirankumar1810455","Kishore14112","PARPUL DIXIT S","PRATHIK MS","VISHNU S V","Yadu Nandan S","ASHWINI V ASHU","Keerthana dn","LAVANYA M LAV","Malini Pai N","Nisarga S N","Rakshitha naidu","SANDRAS2000","Yashoda.bg","Dechamma K.R","VASANTH NARAIN","VANDHANA Ganesh","Sheethal R","Shivakumar s7","1820180 Sathvik","Madhuri1820181","1820182rolisha","1820378bhuvanr","1820379charanr","Charan.s","1820480devansh","Harsha chandra prakash","1820578saikrishna","Shiv 1820579","1830966vasanthkumar","1840151sudarshan","pranathi1840152","spoorthi.s1840153","1840361Kedar","1840362vignesh","1840365varshithN","1840366likhitha.s","1840367POOJA","1840368sharanyab","1840369sumanasainath","1840370trishatb","1840384swaroop","1840386nithin","aakash.a","1840452abhi","mathewaswin17","1840455Mrunal","1840456deepakkr","1840457ebenezera","1840459M.VARUN","1840460mahesh","vinay bharadwaj ds","1840464yeshwanth","1840467 Divya.N","1840468 Harsha B S","1840469manashwi","1840470 Pavithra S M","1840471praveena.s","1840472rekha.s","473 SHRUTHI.V","1840474shubhashree","ChristKannada","1840476swathik","1840564 Girish Kumar DV","1840565 GOWTHAM RAJ N","1840566monish","1840567vibin","archana1840568","1840569 Chaithanya.A","1840571chaithraps","Devika. K. M","1840573lathashreej","1840574manasa.b","1840575 Manasi","1840576 Prathima","Priscilla Richard 1840577"," 1840578 tanuja M","Thanuja1840579","1840588 sushmitha.mg","1840466deepthyrosemathew","Yashasv 1840510","1810267archana","1810158francinabuela","1810278ranjini","1810165mani","Sharine 1810173","bharath1810145","1810267archana","MANOJ.KRISHNA.CMS","Dwaitha pc","V Thrishala","DeepikaRavikumar(BCB)","Gagana shetty","Nayana.Nayu","C K SRIHARI","Sonia R Reddy","Achyuta Kaushik","ROSHAN RAVINDRA MALAPUR","Settypalli nagireddy saketh","HEPABHISHEK","Manasa Dindgur","mohith.reddy.cms","Kedarnath Harish","Pri1840740","Bindushree62","Ramesh Doddagowdar","MADHU S KULKARNI","Shalini Srini2000","Aishwarya H R","David Kumar R","Chaithrashree K","N. Aishwarya","Nishitha Nag M.V","Keshava64","Anupama Anand","Nithinpaul365","Deepika Ravishankar","Nithya V P","Sradha.s(BCB)","Nishchit","Tejashwini Srinivasan"," Shanker1997","Varshitha K A","Darshan","Deeksha Sudhindra","M. NEHA JPEng","Kushalkl1810349","sanjitha ajith kumar","bhoomika bs","Sameeksha Mahesh Telang","Spoorthy M N","Y Karun Kumar"," Aishwarya S Rajan","Harshitha1810273","Vaishnavi Guthi","Kshithi ky","SHOBITA S","Ananya Kashyap","Sharanya R Urs","ANARGHYA RAO Y M S","Prajwal B Mantanavar","Bharathanna","Godson Babu Christ","KHAN HANNAH","Sheryl Stephen","cathi saji","Chandana K P","carol Marina .j","Bhumika D Reddy","Bhoomika.N","Gladson Babu Christ","Nama Sanhitha Sunil","Maria david kp","Supriya G A","Prakruti Narayan","Prakruthi jain mp","MEGHANA.L","Anirudh hs","Pavan Kumar S k","PREETHA S. K. CMS","Jatin Dharmaveer","ajithkumar200","Keerthana VijayKumar","Jayanth reddy c","Mythri. C","Velankanni Reena.D","Adya Gowda","Chandan Vasu","SUDHAN PRAKASH S","HK Sridevi","Princy1810370","Arpitha hb","BHAVANI.C199","AISHWARYA MANJUSHREE","Tanmai AR","Tanisha.Sanjay","Shubhada S","Niraj prakash","Moshik Mandanna","Jiya Susan Saji","Taraananth212","Sheetal.nataraj","Harsha varadhan reddy"," Akshay Vishnu Keerthi","NAVEEN HARSHA","1840570chaithra");
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
