databricks-date - python

Question

in databricks using python:

import datetime
currentDateTime = datetime.datetime.now()
monthNo = currentDateTime.month
mypath = 'container/foldername/'

fullpath = mypath + 'month=' + str(monthNo) + '/day=' + str(dayNo)

Question:
How can I get 0 infront of a single digit month or year?

Thank you

Answer 1

Hi @arkiboys ,

Thank you for posting query in Microsoft Q&A Platform.

You can use string formatter in python to do that trick. f"{x:02}" here x represents your number. Please check below image for your idea.

Below link has detailed discussion on same. Kindly check.
https://learn.microsoft.com/en-us/answers/questions/821314/date-folders.html

Hope this helps. Please let us know if any further queries.

-------------

Please consider hitting Accept Answer. Accepted answers help community as well.