#13 Cleaning Time

date
May 17, 2023
slug
13-time
status
Published
tags
summary
Not a productive day
time
0h-15m
type
Post
I didn’t make much progress today, though I tried and spent some time staring at the screen trying to understand, I couldn’t, It was hard, I was missing the obvious things and making blunders. The topic isn’t particularly difficult, its just there are other things running on my mind. Total time spend actively learning would’ve been around 15ish mins.
Having a clean data set from the start will help save significant time later during analysis.
 
Conversion b/w different data data
  • Text(number,format) can be used for easy interconversion
    • mmm → jul
    • mmmm → july
    • ddd → Fri
    • dddd → Friday
  • YEAR() → YYYY
  • MONTH() → MM (July is returned as 7 rather than 07)
  • WEEKDAY(date,[type]) second optional argument describes which day the weeks starts with, it defaults to 1 for Sunday.
  • HOUR() & MINUTE() & SECOND()
 

© ibrar 2023