Set up FTP user with ProFTPD on Ubuntu

Question

I have date in format 2013-08-05 12:45:56. But I want to store this in format 2013-08-05 00:00:00 in database.

The thing I want is, I don't want to save the time in database.

I am using:

cmd.Parameters.AddWithValue("@VoucherDate", VoucherDate.Date);

But still it is saving the time. Any suggestions?

Solution

Just had this problem with Ubuntu 12.04.2 and ProFTP. I had my FTP user's shell set to /bin/false and ProFTP wouldn't allow that to connect (it showed Error 530).

What I did was followed I uncommented this on my /etc/proftpd/proftpd.conf:

RequireValidShell Off

And I also added /bin/false to my /etc/shells file.

Restart ProFTP and you're good!

Hope this saves someone time.

Comments

[Fahad Murtaza]

is there no any other way that I pragmatically save ONLY the date?

[Mikael Östberg]

This is not an optimal solution and the reason for this is because dates should be stored as dates (which is actually a 3 byte number). This answer casts the date into a string which is just wrong for all purposes but presentation. Please see the answer from @christiandev instead.

[Daniele]

@Mikael Östberg You are right, i just showed a fast solution, the ToShortDateString should be used for presentation pourpouse as you stated