Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I sometimes need to type the current date + time in MySQL format, ie. YYYY-MM-DD HH:MM.

Before I write one myself, does someone know of a Windows applet that does this, so I could just double-click on it, and paste the clipboard elsewhere?

Thank you.


Edit: Turns out it was pretty easy to do in Freebasic, although it's a console applet instead of a GUI applet:

#include "vbcompat.bi"
#include "windows.bi"

Sub ClearClipboard(hwnd As HWND = NULL)
    OpenClipboard(hWnd)
    EmptyClipboard()
    CloseClipboard()
End Sub

Sub WriteClipboard(Text As String, CPFormat As Integer = CF_TEXT, hWnd As HWND = NULL)        
    Var hGlobalClip = GlobalAlloc(GMEM_MOVEABLE Or GMEM_SHARE, Len(Text)+1)        
    OpenClipboard(hWnd)
    EmptyClipboard()
    Var lpMem = GlobalLock(hGlobalClip)
    CopyMemory(lpMem, StrPtr(Text), Len(text))
    GlobalUnlock(lpMem)
    SetClipboardData(CPFormat, hGlobalClip)
    CloseClipboard()
End Sub        

Dim a As Double = Now()
Dim CurrentDateTime as String

ClearClipboard()
CurrentDateTime = Format(a, "yyyy-mm-dd hh:mm")
WriteClipboard(CurrentDateTime)
share|improve this question
1  
Answers belong in the answer box. –  Ignacio Vazquez-Abrams Jun 1 '11 at 10:24
    
I always thought applet refereed to the java specification? Maybe just me... –  slotishtype Jun 1 '11 at 11:14

1 Answer 1

I quickly made an HTA utility to do that named GetMySQLDateTime using VBScript. Feel free to use/modify/redistribute it for any purpose. As it's a HTA, you may directly modify the code using any text editor.

Screenshot

Usage: Just run it and the string will be on your clipboard. Click "Refresh" button to update it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.