CODEWITHSUNDEEP
pythondatetimeamazon-web-servicesamazon-dynamodbboto
Alexander Perechnev
Alexander Perechnev

Reputation: 2837

Is it possible to save datetime to DynamoDB?

I have the next code:

users_table = Table(users_table_name, connection=Core.aws_dynamodb_connection)
users_table.put_item(data={
  "login": login,
  "password": hashlib.sha256(password.encode("utf-8")).hexdigest(),
  "profile": profile,
  "registration_date": datetime.now() # PROBLEM IS HERE
})

But when I run it, it fails with error:

TypeError: Unsupported type "< type 'datetime.datetime' >" for value "2015-01-12 05:02:57.053131"

I've tried a lot of ways, but it seems that it isn't possible to save datetime to DynamoDB. Btw it works fine in MongoDB.

Is there any solution?

Upvotes: 54

Views: 72124

Answers (9)

Ruelos Joel
Ruelos Joel

Reputation: 2389

with DDB2, seems like Instant is now supported.

https://github.com/aws/aws-sdk-java-v2/tree/master/services-custom/dynamodb-enhanced#changing-update-behavior-of-attributes

Upvotes: 1

dvoelker
dvoelker

Reputation: 101

old post but maybe still interesting ..

What you can do and how it worked for me:

import datetime
from datetime import datetime

...

now = datetime.now()
x = now.strftime("%m/%d/%Y, %H:%M:%S")

 table.put_item(
           Item={
               'Index': Index,
           
               'Stamp': x,
               
            }
        )

And with adaption to the code above:

import datetime
from datetime import datetime

...

now = datetime.now()
x = now.strftime("%m/%d/%Y, %H:%M:%S")

users_table = Table(users_table_name, connection=Core.aws_dynamodb_connection)
users_table.put_item(data={
  "login": login,
  "password": hashlib.sha256(password.encode("utf-8")).hexdigest(),
  "profile": profile,
  "registration_date": x, 
})

My Output

You can see the format in the DB

Upvotes: 8

user1855042
user1855042

Reputation: 641

According to alejandro-franco response .isoformat() make the trick.

Just tested and this a working example:

CustomerPreferenceTable.put_item(
    Item={
        "id": str(uuid4()),
        "validAfter": datetime.utcnow().isoformat(),
        "validBefore": (datetime.utcnow() + timedelta(days=365)).isoformat(),
        "tags": ["potato", "eggplant"]
    }
)

Upvotes: 19

alejo4373
alejo4373

Reputation: 115

Reading the documentation lately, I found the right link to the documentation here. The recommended way to store date and time data in DynamoDB is using ISO 8601 strings. so the data type is just string.

Upvotes: 4

Fred Campos
Fred Campos

Reputation: 1617

According to the documentation: http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/JavaSDKHighLevel.html

Date S (string type). The Date values are stored as ISO-8601 formatted strings.

Upvotes: 14

H6_
H6_

Reputation: 32808

These are all the supported types for attribute values in DynamoDB as listed in their AWS Docs.

B A Binary data type.

Type: Blob

Required: No

BOOL A Boolean data type.

Type: Boolean

Required: No

BS A Binary Set data type.

Type: array of Blobs

Required: No

L A List of attribute values.

Type: array of AttributeValue objects

Required: No

M A Map of attribute values.

Type: String to AttributeValue object map

Required: No

N A Number data type.

Type: String

Required: No

NS A Number Set data type.

Type: array of Strings

Required: No

NULL A Null data type.

Type: Boolean

Required: No

S A String data type.

Type: String

Required: No

SS A String Set data type.

Type: array of Strings

Required: No

Upvotes: 1

Anzel
Anzel

Reputation: 20553

I'm not sure why datetime isn't supported in DynamoDB, or in fact I have no experience in it neither.

But if you're so insisted in not converting the datetime to string like people suggested, you can convert the datetime to timestamp, and so you can compare with it.

updated

And you may want to read this SO Question, seemed like numeric comparison is the preferred way.

Upvotes: 3

Alexander Perechnev
Alexander Perechnev

Reputation: 2837

Okay, I see that DynamoDB does not support any date types. So the only solution is to use unix-like time as integer, or save date as string.

enter image description here

Upvotes: 41

Stephen Lin
Stephen Lin

Reputation: 4912

If you want to use date to find users, you can simply invoke date() function. Like this:

...
users_table = Table(users_table_name, connection=Core.aws_dynamodb_connection)
current = datetime.now()
users_table.put_item(data={
  "login": login,
  "password": hashlib.sha256(password.encode("utf-8")).hexdigest(),
  "profile": profile,
  # here use a different name for the entry
  "registration_time": current
  "registration_date": current.date()
})
...

Upvotes: 2

Related Questions